I am trying to flow so that I can change the status of two lists in sharepoint, so one list updates a status field through an approval and the other list has several fields to update the tbm status field, but I can't connect to second list and approve both at the same time, he sends two emails for approval and that, I don't want to.
Would anyone have a solution?
Let me know if I have the gist of this correct: You have two lists in SharePoint, and one list needs an approval with a status field update, and the second list has multiple fields that also need to get updated when the item from the first list is approved.
Can I get a screenshot of what you've tried so far? How is the flow triggered, is it for a selected item or does it happen automatically when an item is created?
You can add multiple Get Items actions to your flow, doing the second one with a filter query based on a value from the first one. Once you've pulled together your data from both lists you can add a Start and wait for an approval step and add variables into that approval from both lists, resulting in one "combined" approval. Here is a very basic outline:
Since you're working with users--and potentially with people picker fields-- let me also direct you to this answer I gave on a similar situation: https://powerusers.microsoft.com/t5/General-Power-Automate/Send-email-with-all-items-in-a-list-to-as...
The answer I provided there should help you with grabbing all the data from the second list based on a particular user from the first list. The important thing for you is that you can get data from two sources and hold that data in variables, thus making everything available in the same approval.
Hope that helps!
If this response provided an answer to your question please mark it as a solution so that others can find it.
If you found this helpful, consider giving it a thumbs up!
What results do you get when you run that flow? What you built here should give you data from both lists, but it looks like you're missing the part where you need to filter your second Get Items action based on the results you're getting back from the first Get items action. I don't 100% know your use case, so that's my best guess based on the information you provided yesterday. Use the "filter query" part of Get items, under the Advanced options. To filter on a particular person, please refer to the other answer I linked in my post to you yesterday.
I will explain my case to you, I hope you understand, the flow I need is that there is a list with id I need to pull the items: "expensemaster" (list1)
The other list is where each user's expense items are: with the "id" of the first, I'll explain further.
Imagine that he creates an item or modifies it in a list, after which he has to make the flow make two approvals, the first is for a manager and another for an end user.
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021