Unanswered

Help with list Shift Time off requests to Excel

(0) Share

Report

Posted on by Community Power Pla...

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 @Anonymous

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

AnthonyAmador 2,553 Moderator on at

Like (0)

Report

Hi @Anonymous

Can you share your flow to better understand your requirement?

Cheers.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on at

Like (1)

Report

Hi @Anonymous

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.

Was this reply helpful? Yes No