The Top 10 Power Automate Community Blogs of 2019

Hi Readers

This list might help you to refer to these blogs when you need it. If you haven’t read it yet, click on the link and read it. I have also provided the URL of Author’s website (just in case you want to check out their awesome work). Please note that my list doesn’t include blogs from MSFT Employees. And is based on no. of maximum views on a blog post per month for e.g. if in January there were 5 blogs (Blog Post 1, Blog Post 2, Blog Post 3, Blog Post 4, Blog Post 5, ) with no. of views 5000, 4000, 3000, 2000, 1000 respectively; I have picked Blog Post 1 as top of that month.

Following are the top 10 by month:

MonthBlog Title No. of ViewsAuthorAuthor’s WebsiteTwitter
January’19Top 5 Microsoft Flow features from the April 2019 release notes 2976Daniel Laskewitz https://www.o365dude.com/ https://twitter.com/laskewitz
February’19Send a summary email of Microsoft Team Channel conversations/posts to all members on a schedule 6473Reza Dorani https://rezadorrani.com/ https://twitter.com/rezadorrani
March’19Create Planner Task and Include Attachments From Outlook Email 17908Alan https://www.alanps1.io/ https://twitter.com/AlanO365
April’19Create Planner Tasks from New SharePoint List Item 5801Laura GB https://hatfullofdata.blog/ https://twitter.com/Laura_GB
May’19How to add a text watermark to a PDF document using Microsoft Flow or Azure Logic Apps 1904Anton Khritonenkov https://medium.com/plumsail https://twitter.com/antonkhrit
June’19Automation Squared using MS Flow and UiPath 5576Yash Agarwal https://www.bythedevs.com/ https://twitter.com/yashagarwal1651
July’19The Four M’s of Microsoft Flow 2031Melissa Hubbard https://melihubb.com/ https://twitter.com/melihubb
August’19Microsoft Flow to Provide Item Level Permission on SharePoint List 2029Siddharth Vaghasia https://siddharthvaghasia.com/ https://twitter.com/siddh_me
September’19Extract data from documents with Microsoft Flow 2439Jay Goodison https://blog.encodian.com/ https://twitter.com/encodian
October’19Microsoft Flow as a Service2199 Yash Agarwal https://www.bythedevs.com/ https://twitter.com/yashagarwal1651
November’19Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A Functional Consultant 1871Prashant Shukla https://diyd365.com/ https://twitter.com/DIYD365
December’19Power Automate & To-Do – The Beginning of a Beautiful Relationship2232Sharon Sumner https://power-full.blog/ https://twitter.com/Sharon__Sumner

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

The Top 5 Most Watched YouTube Videos of DIY D365 in 2019

Hello Readers

christmas

First of all a big thank you for your support in 2019. Please continue supporting.

Following is a list of top 5 videos which you liked and watched the most:

Rank Blog Post Views Hours watched Series
1 The Secrets of Dynamics 365 Wave 2 (preview) 1326 137.8 Previews
2 Episode 5: Easy Power Apps Hacks To Make Your Users Life Easy 2365 123 PowerApps Tutorial
3 TGIF Episode 2: Building Your First Flow (Power Automate) 2293 118 Thank God It’s Flow
4 Episode 6- Embedding Canvas App in Model Driven App 1552 100 PowerApps Tutorial
5 TGIF Episode 3: Most Common ODATA Filter Queries for MS Flow (Power Automate) 2073 100 Thank God It’s Flow

If you’re new here or haven’t watched it yet, click on the link to watch.

A lot of people have reached out to me on the videos asking questions and also how it has helped them; that’s awesome 🙂

Note: No. of views was accurate as at 12/12/2019. Ranking is based on the hours watched on my YT channel.

Thanks for reading!

Subscribe to my channel and follow my blog.

The Top 3 DIY D365 Blogs in 2019

Hello Readers

christmas

First of all a big thank you for your support in 2019. Please continue supporting.

Following is a list of top 3 blog posts which you liked the most:

Rank Blog PostViews
1Every PowerApps Formula You Ever Wanted To Know As A Functional Consultant 3136
2Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A Functional Consultant 2317
3Make A Better First Impression With Visitor Sign In App (PowerApps)2173

If you’re new here or haven’t read it yet, click on the link and have a read.

Most views I got were on Home Page/ Archives 13150 but that can’t be classified as a blog so no mention in the ranking table.

Note: No. of views was accurate as at 12/12/2019. Ranking is based on the views I received on my website and powerusers community blog.

Thanks for reading!

Subscribe to my channel and follow my blog.

How to fix the subgrid in Dynamics 365 UI?

Hello Readers

This blog is part of my quick tip series and will be short.

if you’re struggling with the responsive subgrid in Dynamics 365 and want to permanently fix it, regardless of the screen resolution/zoom or device; here’s the solution:

Look at the problem first-

Sub-grid 1-You see a sub-grid like this:

1

Sub-grid 2-And it changes to this when you zoom out or change the resolution:

2.png

So how can you make sub-grid 2 appear all the time?

Step 1:Go to advanced settings

3.png

Step 2:Customisations or solutions depending on the need

Step 3:Entity>>Form

Step 4:Double click the sub-grid on the form

Step 5:Click controls

Step 6: Select ” as a control

Step 7: Select ‘Grid only’ under “Reflow behaviour”

4

Step 8: Save and then publish

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 8: Top Reasons to Use Power Automate (Power Automate vs Dynamics 365 Workflows)

Hi Readers and Viewers

Merry Christmas and a very Happy New Year! Thanks for your support in 2019 🙂

In this video, we will look at the top reasons for you to start using Power Automate. Also, this is the last episode of the series so I thought what’s better than a comparison. If you remember, in my first episode I asked you that have you found your reason to use Power Automate yet? Well, if you haven’t I am giving you the reasons in this episode.

Power Automate FlowDynamics 365 CE Workflow
No Code SMS Integration https://txtsync.com Not OOTB
Social Media IntegrationNot OOTB
Convert to PDF (Multiple ways available)Not OOTB
Copy Salesforce Account/Contacts to D365Not OOTB
Sync email attachements to OneDriveNot OOTB
Gmail to Dynamics 365 and Dynamics 365 to Google calendar Not OOTB
Updating 1 to Many relationship recordsNot OOTB
Update a lookup field from text field
https://diyd365.com/2019/03/12/update-a-lookup-from-a-text-field-no-code-solution/
Not OOTB
Update opportunity/order/quote from opportunity/order/quote close forms
https://diyd365.com/2019/09/13/how-to-update-an-opportunity-from-opportunity-close-and-send-an-email-on-opportunity-close-using-ms-flows-no-code-solution/
Not OOTB

Everything in the list above is in context of Dynamics 365. Out of the box (OOTB) Dynamics 365 workflows can’t do any of the above. You will have to create a custom workflow (#code) or a plugin (#code).

Hope I have given you reasons to start working on Power Automate.

Video here:

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 7: Using Power Automate (Microsoft Flow) Mobile App To Build A Flow

Hi Readers and Viewers

In this blog & video, we will look at the ease of using ‘Power Automate’ Mobile App.

First half of the blog talks about the app structure and components/features available (Almost everything is available)

Second half of the blog includes a video where I am demonstrating the app and also create a Flow via Power Automate Mobile App.

Download the app from apple store https://apps.apple.com/au/app/power-automate/id1094928825

Download the app from google play store https://play.google.com/store/apps/details?id=com.microsoft.flow&hl=en

First up, what’s available in the mobile app?

  1. Activity
    • Feed
    • Approvals
  2. Browse
  3. Buttons
  4. Flows
  5. Account

Activity Section

Feed tab

  • You can check the sessions of your Flows here.
  • You can check any notifications you received here.

Approvals tab

  • You can check the approvals list here

Browse Section

Browse Templates by Services

  • Browse by services like Excel, OneDrive etc.

Browse Templates by Categories

  • Browse by categories like mobile, featured, collect data etc.

Button Section

  • All your on-demand flows triggering on a button click are here or can be created from here

Flows Section

  • All your flows will be visible here along with the last run status.
  • All your button flows or on-demand flows will be visible here as well
  • You can click on the flow to perform the following actions:
    • Enable/Disable flow
    • Edit/Modify flow
    • Check owners/Share flow
    • Run history of the flow
    • Save as
    • Delete the flow

Account Section

  • This is where all the settings for your Power Automate App/Account are available. Following actions can be performed here:
    • Select/Change Environment
    • Help and Support
      • Learn
      • Contact Support (Support.microsoft.com)
      • Suggest a Feature (Powerusers Power Automate idea page)
    • About
      • Version
      • License Terms
      • Third Party notices
    • Privacy
      • Privacy (privacy.microsoft.com)
      • Send usage data (yes/no)
    • Give feedback
      • How was your experience?
      • Contact Support
        • Visit community
        • Open support ticket

Video on using the app here:

Hope you find it helpful!

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Quick Tip on UI Flows (Power Automate, renaming a UI flow)

Hello Readers

This quick tip is part of my Thank God it’s Flow #TGIF series. There are two tips in this post:

  1. Renaming your UI flow
  2. Modifying and removing connections

Renaming your UI Flow: For general flows you just hit on the pencil/edit button and can rename them by clicking on the name at the top as shown below:

Screen Shot 2019-12-08 at 1.41.09 pm.png

This doesn’t work for UI Flows. Instead you have to click on the name and the click the edit button shown in the screenshot below:

Screen Shot 2019-12-08 at 1.35.17 pm.png

Modifying and removing connections: 

All connections are available under Data on the left navigation. So if you reach maximum connection limit and are thinking how to delete/remove one. Here is the place. Just click on the ellipses (…) and select an option

Screen Shot 2019-12-08 at 1.36.42 pm.png

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!