I'm fairly new to Power Automate, I'm able to create approval flows and basic list updates from Forms etc but im a bit stuck on the steps to create a flow which does the following:
1. Data is captured into a Sharepoint List from a Microsoft Form submission (already created a flow that works for this).
2. I'd like to update the SharePoint list values against unique reference numbers (URN) and return a specific name associated from the excel file.
Any help would be much appreciated!
so to understand you correct: When a new item is created in a SharePoint list (by another flow from MS Forms), you want to update this item using a second flow. This flow will check in an Excel-List in a column "unique reference numbers (URN)" for a specific value, and then updates the same item in SharePoint with some values from this Excel, right?
A couple of things to consider:
1. I would recommend instead of using two flows to update your first flow. This will make it easier to manage the whole process and make it easier to maintenance.
2. Nevertheless how you build your flows, you would need to do the following:
If you are using two flows, please make sure you are using the "When an item is created" and not "When an item is created or updated", otherwise you will run into a loop, because the flow is always starting itself again. Thats another reason to consider using one flow instead of two.
Does this help you? Otherwise please give me some more information.
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
Hi @MarvinBangert ,
Thanks for your response and guidance. To clarify im going to add some images to illustrate what im trying to do.
I agree, merging the two flows into one is what I want the end result to be so long as the run time is not excessive.
I think your understanding for my help request is right 🙂
Thanks again for your support!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!