cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AntonyCole
New Member

Help with list Shift Time off requests to Excel

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 

 

3 REPLIES 3
AnthonyAmador
Community Support
Community Support

Hi @AntonyCole 

 

Can you share your flow to better understand your requirement?

 

Cheers.

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

pic1.jpg

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"

 

AnthonyAmador_0-1637852998624.png

Then a called the two actions below.

 

AnthonyAmador_1-1637853111336.png

 

I create an "Apply to each" based on "Time Off Instances List". 

AnthonyAmador_2-1637853302854.png

 

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.

AnthonyAmador_3-1637853899972.png

AnthonyAmador_4-1637854070608.png

AnthonyAmador_5-1637854301652.png

AnthonyAmador_10-1637855279580.png

 

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.

 

AnthonyAmador_6-1637854540840.png

 

Finally I create the new row in the Excel table, all the flow should look like this. 

 

AnthonyAmador_8-1637854811213.png

AnthonyAmador_9-1637854860432.png

 

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,739)