Identify workbook location , workbook library, workbook of the logged in user

(0) Share

Report

Posted on by Venkatz

Hi.

I am trying to use Power Automate to retrieve the contents of excel which is available in the logged in user OneDrive.

In Instant cloud flow - Manually trigger a flow - Excel online (Business) - Run script from Sharepoint library.

How to choose the workbook location , workbook library, workbook of the logged in user who trigerred the flow ?

Currently I am able to choose mine, who is creating the flow. But the data needs to be picked for the user who is trigerring the flow. The file name "abc.xlsx" is available in the OneDrive of every user.

How to achieve this functionality ?

Thank

Categories:

Licensing

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

David_MA 12,005 Super User 2025 Season 2 on at

Like (1)

Report

Identify workbook location , workbook library, workbook of the logged in user

It is found here on the detials screen of your flow:

Was this reply helpful? Yes No
Venkatz 6 on at

Like (0)

Report

Identify workbook location , workbook library, workbook of the logged in user

Hi.,

Thanks for the response.

Could you please help to show where is this option available?

Was this reply helpful? Yes No
Verified answer

David_MA 12,005 Super User 2025 Season 2 on at

Like (1)

Report

Identify workbook location , workbook library, workbook of the logged in user

If the flow is manually triggered, usually the default setting for actions is for the credentials to be provided by the run-only user. Edit the run only user settings and make sure the OneDrive action is set to:

Was this reply helpful? Yes No