Tag: powerplatform

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 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.

#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 Episode 4: Understanding ‘Scope’ in Flows (Power Automate)

Hello Readers and Viewers

In this episode we will try to understand ‘Scope’ in flows. This is a comparatively short episode as I have used visuals to explain scope.

Scope is available in following categories:

  • User
  • Business Unit
  • Parent Child Business Unit
  • Organisation
  • Custom (Yes, you can enter a custom value)

Dynamics 365 people, does it reminds you of something? Yes, you guessed it right. This is coming from scope of native D365 workflows. But in Power Automate scope is only available if you’re using Common Data Services (CDS) as a data connection. I am providing some screenshots below which might help:

Screen Shot 2019-11-23 at 10.34.04 amScreen Shot 2019-11-23 at 10.35.14 amScreen Shot 2019-11-23 at 10.37.06 amScreen Shot 2019-11-23 at 10.38.26 am

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!

Using Timer Control In PowerApps (with problem scenarios and Business use cases)

Hello Readers and Viewers

This blog/video is part of my quick tip series. We are going to look at how we can force a screen to be visible to a user irrespective of the transition, in other words delay screen transition.

Skip to the video, if you don’t want to read

Example Problem 1: if we want to Navigate to more than one screen back to back only the last screen mentioned in navigate formula is visible to the user; that means one navigate screen is skipped. for e.g. look at the formula below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade);Navigate(lstMembers)

If you apply the above formula to your Power Apps, users will always end up seeing “Navigate(lstMembers)” and the success screen is skipped.

Example Problem 2: if we remove the last bit of the formula and have only one ‘navigate’ as shown below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade)

if you apply the above formula, users will have to touch on the success screen somewhere to be able to see any other screen. (assuming success button in below screen will have navigate formula)

b1

Solution to both the example problems: First of all remove the last navigate from the formula and only have one navigate, shown below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade)

Note: I am not saying you must use the exact same formula as above, you need to change the formula as per your need but only have one navigate in the formula.

Now on your success screen add a timer by going to Insert>>Input>>Timer

b2.JPG

Set AutoStart to true

Set the duration of the timer by clicking on the timer on screen (Completely on your requirements, for how long you want a user to see a screen)

1000=1 second 5000=5 seconds 30000=30 seconds

Set OnSelect to false

b3b4b5

Set the second navigation on your ‘TimerEnd’ property

b6

Now hide the timer, so your users can’t see it

b7

And all done, your users will now be navigated to the screen of choice without having to click anywhere.

Business Use Case: You want your users to see a success screen for ‘n’ seconds and then auto-redirect to a list or another form.

Video here:

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

#TGIF Episode 2: Building Your First Flow

Hi Readers and Viewers

In this episode, we will deep dive into Power Automate and will create our first flow. We are also going to see different types of flows available within Power Automate. We will look at the following scenario to create our flow:

Scenario: Assign Territory to a customer based on the ‘Address 1: ZIP/Postal Code’ field in CDS/D365. (Address 1: ZIP/Postal Code is a text field)

Out of the box what’s available: Territories are related to ‘postal codes’ as 1: N relationship. Both Territory and Postal Code are available OOTB in CDS/D365. But on Account form, ZIP/Postal Code is a text field so how do we perform this action without any coding efforts.

Solution before Power Automate (MS Flow): If flow wasn’t there, we would have to create a plugin which will trigger post-operation/ record creation and check the value of ‘Address 1: ZIP/Postal Code’ in the data table of Postal Code and then pick up a related territory to update that territory on account form and the efforts required to that plugin would not be less than 4 hours.

Solution after Power Automate: Thank God it’s Flow! with the help of flow you can achieve the results in 5 minutes or less.

Watch the video here:

Fundraising for Rural Aid Australia- TGIF Shirts, here.

Descriptive blog post here.

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!