Power automate export data to onedrive to allow for all users

[vilenm]

Hi

I have a power automate button that triggers an export to csv to onedrive downloads folder. Some users do have access to run the flow but when they do it saves it to my when drive. How can I get it to dynamically change to current users drive?

[sanprasa]

Hi, If anyone know the solution for this kindly let me know i m trying to find the solution for last one week did not succeed.

[vilenm]

Hi, I ended up using sharepoint or teams as central location where users were given access to that central location

[lbendlin · Accepted solution]

Interesting question.  When you trigger the flow you do not only get the Power BI data as a table, but also meta data on who triggered the flow 

Basend on that you should be able to set the destination sharepoint/onedrive for that csv data.  However, this also means that you need to share your flow with all potential users, and all potential users may need to share their Onedrive with you.  That's most likely not an acceptable setup.