Help with list Shift Time off requests to Excel

[AntonyCole]

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 

[AnthonyAmador]

Hi @AntonyCole 

Can you share your flow to better understand your requirement?

Cheers.

[AntonyCole]

Hi, Thanks for coming back to me. I have attached a picture, hope it makes sense to you.

[AnthonyAmador]

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.