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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,937)