Hi,
Complete newbie to Power Automate, but I have managed to create my first flow which pulls data from Shifts Time off requests into Excel. I need to know a few things. How I can insert the Users name instead of UserID, and Reason instead of reason ID. Can't seem to find and answer i'm looking for, or how to put it together. Thanks in advance @AntonyCole
Hi, Thanks for coming back to me. I have attached a picture, hope it makes sense to you.
Hi @AntonyCole
This is the flow I made for your requirement, this does not mean that is the only one or that it cannot be optimized.
First I declare two variables, "DisplayName" and "Time off reason"
Then a called the two actions below.
I create an "Apply to each" based on "Time Off Instances List".
In the Scope I get the "Time Off reason", first I filter the "List of Time Off Reasons" and then I set the Time off reason variable.
In the Scope 2 I get the name of the user using the "Get user profile" action from Office 365 Users connector and then I set the Display Name variable.
Finally I create the new row in the Excel table, all the flow should look like this.
Hope this helps.
Kind regards.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
23 | |
17 | |
17 | |
13 |
User | Count |
---|---|
125 | |
34 | |
30 | |
28 | |
26 |