Power Automate Exchange Community Blog

Create a New Blog Post  View Your Unpublished Blogs 

CDS ‘List Record’ action limitations : Power Automate

By Nagaraja Emmadisetty posted 10 hours ago
Be the first person to recommend this.
We use   ‘List Record’   action on an entity to retrieve multiple records . By default, This action retrieves maximum of   512   records. The flow would run successfully even if we have more records, but, it will return only the first 512 and   skip other records . We came across this scenario and we didn’t realize that it is skipping records. Later , we adjusted the setting to resolve this issue. Here are the steps. if we have premium plan like power apps plan 1, power apps plan 2 and other, we can increase the limit up to   100000.  By default,   Pagination   is off. Switch it on and adjust the limit. As you can see above, ...
0 comments

Local User Group Highlight: Cambridge Power Platform User Group

By Erin Gregoire posted 4 days ago
Be the first person to recommend this.
User Group Spotlight – this week we would like to showcase one of our local user groups that continues to bring knowledge and awareness around the Power Platform products – the Cambridge Power Platform User Group led by Sharon Sumner. Their first meeting in 2020, they will be bringing in a couple outstanding speakers to discuss Power Apps and Power Automate that you don't want to miss!   Cambridge Power Platform User Group UG Leader : @Sharon Sumner Sharon is the CEO of Business Cloud Integration Ltd, SharePoint and Office 365 delivery partner in Cambridge UK. She leads the Digital Transformation Team - helping businesses adopt the ...
0 comments

Using Service Principal in Power Automate/Flow

By Nagaraja Emmadisetty posted 5 days ago
Be the first person to recommend this.
Any   CDS   trigger or action requires a connection to   CDS   environment. While adding connection, we can choose to sign in with individual user account or   Service Principal. If we choose to sign in with individual user , CDS action runs in that user context and in auditing it shows as the user performed that action. It may cause problems in some scenarios like audit checks/troubleshooting. So better way to do it is sign in with service principal / application user. By creating service principal, we are indirectly creating an   identification for the flow. Read more here on my b
0 comments

Terminate Control : Power Automate/Flow

By Nagaraja Emmadisetty posted 6 days ago
Be the first person to recommend this.
Have you ever thought of terminating power automate/flow if condition is not met ? Recently I have come across this scenario and I used ‘Terminate’ control to achieve this. Read more here
0 comments

Tip: Sharing Power Automate with Groups

By Nagaraja Emmadisetty posted 8 days ago
Be the first person to recommend this.
Flow enables you to share flows with your colleagues either by adding them as co-owners or run-only users (for manual flows only). As co-owners, they have full edit permissions for the flow. As run-only users of manual flows, they can only run the flow. Not only individual users, we can add   office 365 groups   also as co-owners to a flow. Read more on  my blog Follow my  blog
0 comments

Power Automate : Change sets feature

By Nagaraja Emmadisetty posted 12 days ago
Be the first person to recommend this.
To understand this feature better, Lets take an example of Banking transactions. I am from India . Currently working in Netherlands. I usually transfer money from my NL account to IND account almost every month. Deduction from my NL account and Credit into my IND account are part of a single   transaction . What does it mean ? It means that if any failure occurs in between deduction and credit , the whole action should be rolled back. This is called   Atomicity . Atomicity is part of the ACID model (Atomicity, Consistency, Isolation, Durability), which is a set of principles used to guarantee the reliability of database transactions. ...
0 comments

When a record is created, updated or deleted trigger for CDS: Power Automate

By Nagaraja Emmadisetty posted 12 days ago
Be the first person to recommend this.
Earlier we were able to trigger Power Automate (Flow) on only one CDS trigger . i.e create, update or delete. Now, we have option to configure multiple triggers. If you are not able to view the trigger ,   you might be using the wrong connector. There are 2 connectors available for CDS in Power Automate 1.Common Data Service 2.Common Data Service ( Current Environment ) If you are not able find   Common Data Service ( Current Environment )   connector, you might be creating Power Automate   outside of CDS solution. Common Data Service ( Current Environment )   connector is not available outside of CDS solution, so you would not be ...
0 comments

Degree of Parallelism in Power Automate

By Nagaraja Emmadisetty posted 12 days ago
Be the first person to recommend this.
What is Degree of Parallelism ? The number of loop iterations that can run at the same time, or in parallel. Degree of Parallelism in Power Automate? Lets take a scenario of updating child records on update of parent record. One of the most used controls is   ‘Apply Each’   which is used to process a list of items. By default, loops run in sequence (essentially, parallelism is 1) . That means only one child record is processed at a time. So, in some scenarios if the number of child records is more , flow takes more time to complete. In my case, it took   more than 4 minutes   to process   100   records. We can improve the flow performance ...
0 comments

User Group Leader Spotlight: Ike Ellis - San Diego Power Platform User Group

By Erin Gregoire posted 19 days ago
Be the first person to recommend this.
Our User Group Leader feature this week is someone who defines the meaning of community by making the topics at his user group meetings educational, fun and open to anyone that has a passion for the Power Platform products to come and speak! He truly believes his user group meetings should be "just a quick, informal meeting where we make friends and help each other out." Ike is a speaker himself and will be speaking at the upcoming Power Platform World Tour in San Diego! His session will cover “Power BI Premium for Fun and Profit” – don’t miss the chance to discover all of the features of Power BI Premium, what it has to offer and if it’s the right fit ...
0 comments

SharePoint Dynamic URL Encoding using 'replace' function

By Kaushal Kodagoda posted 21 days ago
Be the first person to recommend this.
SharePoint connector functions sometimes don't work with URLs like below:          /account/TEST/opportunity/539AEB5DC10BEA11A811000D3AF3AC9D/Report.xlsx However, after Encoding the URL, connector works:  %2Faccount%2FTEST%2Fopportunity%2F539AEB5DC10BEA11A811000D3AF3AC9D%2FReport.xlsx Flow does't have an in-built function to encode URL's. Use below code to encode any SharePoint Dynamic URL per UTF-8.  1. Initialize 2 String variables: SP_Location, Encoded_URL   2. Set SP_Location = {Sharepoint File Location} 3. Set Encoded_URL value as below: Replace the expression with following code:  replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace ...
0 comments

Where to Next? Power Platform World Tour Heads to Australia - it's not too late to register!

By Erin Gregoire posted 23 days ago
Be the first person to recommend this.
On the 21-22 of November, the Power Platform World Tour will be making its way across the globe to Sydney, Australia for 2 information-packed days with 32+ sessions focused enhancing your Power BI, PowerApps, and Microsoft Flow skills. The event will kick-off with attendees having the chance to hear directly from the Power Platform product source, Microsoft.   Keynote Speakers Michael O'Keefe , Business Group Leader for Business Applications at Microsoft   Charles Sterling , Senior Program Manager at Microsoft Andrew Coates , Senior Software Engineer at Microsoft Alice Drummond , Director of Environmental Analytics and Co-Founder ...
0 comments

New Leader and User Group Spotlights!

By Erin Gregoire posted Nov 09, 2019
1 person recommends this.
As the Power Platform products continue to evolve, we are seeing more and more interest of individuals or groups willing to start up new local user groups in their area to learn and engage with their peers. With the recent update from Microsoft Flow to Power Automate and the added Power Virtual Agents, the momentum around the Power Platform will just continue to increase. These leaders have recently started new user groups in their area to continue this POWER momentum! Welcome to the leader community ! Join their groups or find the local UG in your area! Power Automate User Groups Are you looking to become a leader ...
0 comments

Big News! Microsoft to Speak at the Power Platform World Tour in Milan

By Erin Gregoire posted Nov 06, 2019
Be the first person to recommend this.
Big News! Microsoft to Speak at the Power Platform World Tour in Milan On 19-20 November, the Power Platform World Tour is making a stop in Milan for 2 information-packed days with 32+ sessions focused on honing your Power BI, PowerApps, and Microsoft Flow skills. The event will kick-off with attendees hearing directly from the Power Platform product source, Microsoft. Keynote Speaker Jon Levesque , Senior Program Manager at Microsoft, will be joining the Power Platform team from Dynamic Communities on the main stage to deliver the featured keynote presentation. Jon manages the pillars of community, evangelism, and engagement ...
0 comments

User Group Leader Spotlight: Prashant Shukla - Brisbane PowerApps & Flow User Group

By Erin Gregoire posted Nov 01, 2019
Be the first person to recommend this.
Each of our local user group leaders continually bring communities together to share knowledge and experiences about their products to their local user groups. This month, we would like to highlight a leader who has demonstrated just that by showing his eagerness to get a group engaged and expanding the existing Brisbane PowerApps User Group to include Microsoft Flow. He also had a great 1 st kick off meeting in October with approximately 40+ people in attendance! Prashant Shukla is a D365 CE and Power Platform professional with 10 years of consulting and implementation experience. He is exploring social media now which includes expanding this ...
0 comments

September PowerApps and Flow User Group of the Month Winner - Cambridge!

By Jena Coffie posted Oct 08, 2019
Be the first person to recommend this.
Congratulations to User Group Leader @Sharon Sumner  and the Cambridge PowerApps & Flow User Group   for winning the September Leader Challenge! We were excited to talked with the UG Leader to learn more about the local PowerApps and Flow User Group and plans for the rest of 2019 and into 2020.  ​ What has been the most exciting thing for your UG so far? By far the highlights of the group so far have the remote presentations from Seattle – we have had remote sessions with Audrie Mango Gordon and Brian Dang from the Flow and PowerApps product teams. What makes your group successful? I think our success comes from within, we have had ...
0 comments

Local PowerApps and Flow User Group Spotlight: Minneapolis, MN

By Erin Gregoire posted Sep 28, 2019
Be the first person to recommend this.
User Group Spotlight – this week we would like to showcase one of our local user groups that continuously brings their members together to share knowledge and bring awareness around the PowerApps and Flow platforms – the Minneapolis PowerApps and Flow User Group led by Alexis Bruno. For their next meeting they will be bringing in a Microsoft speaker to discuss the Power Platform licensing changes occurring in October. Minneapolis PowerApps and Flow User Group UG Leader : @Alexis Bruno Her passion is to help business users improve their current processes to improve productivity and had always loved using InfoPath but was very excited to switch ...
0 comments

Consuming OAuth APIs using Microsoft Flow and Integrating with PowerApps

By Srikanth Kusumba posted Sep 12, 2019
1 person recommends this.
Microsoft_Flow.doc
0 comments

Local User Group Spotlight: Salt Lake City Flow and PowerApps UG

By Rose Spitzer posted Aug 23, 2019
1 person recommends this.
User Group Spotlight – the Flow & PowerApps User Groups are doing amazing things every day. We’re constantly impressed with the passion, dedication and creativity we see in the groups and the members of the community that lead them. This week we would like to inspire you by highlighting one of our groups that have blown us away with their agenda lineup.   Salt Lake City PowerApps and Flow User Group When: Sep 12, 2019 from 3:00 PM to 5:00 PM (MT) Where: Bridge Investment Group, Sandy, UT Agenda:  UG Leader @Greg McMurray   will set the stage with a brief intro to Flow & PowerApps , followed by four awesome demos that ...
0 comments

Use to Flow Create SharePoint Sites, Lists & Fields

By TODD BENSON posted Apr 30, 2019
Be the first person to recommend this.
Introduction I don’t consider myself a master of PowerShell, REST calls or JSON (JavaScript Object Notation), but I understand that these tools have enormous benefit and make life easier for SharePoint development. Those who are experts with these tools, and others, can shape SharePoint sites easily and quickly with scripts. My experience is the opposite: I am not one of those experts. Instead, I have to perform numerous page clicks to burrow into the depths of SharePoint to perform the tedious, and most often repetitive, operations to complete the intended tasks. With the introduction of Microsoft Flow, I was excited that much of what I was doing in SharePoint ...
0 comments

Pinpoint Nearby Customers to a Location using Microsoft Flow & Bing Maps

By Martyn Booth posted Apr 24, 2019
Be the first person to recommend this.
Have you ever thought it would be handy to target your customers within a certain distance of something? Maybe you're throwing an event and want to know how many of your customers are within a 30 minutes drive so you can send them a personal invite? Maybe you're a recruiter and would like to know which of your potential candidates live within a 15 minute walk of the role you're trying to fill? Sure, you could use an advanced find in Dynamics 365 to target customers in a specific city, but that doesn't give you that much info to go on. On the other hand, knowing that your customer is a 5 minute walk around the corner gives you that extra bit of knowledge to ...
0 comments