Unanswered

Power Automate return file to PowerApps for gallery display

(1) Share

Report

Posted on by Lofy

Hello Professionals,

High-level: A power app that allows the logged in user to see only their data in an excel sheet. The sheet is stored in a SharePoint site but I don't want to give general access to see everything in the excel file.

I am trying have an automation that when runs will pull a file that is store in the users OneDrive and display it in a gallery.

I already have an automation from a service account that goes into the sheet takes just that users info out by id and stores it on their personal OneDrive but I cant get PowerApps to dynamically look in their OneDrive. I have tried to create an automation that returns the file id to the PowerApps on the push of a button but I cant get it to display in a reasonable format like a gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

I would work with a power automate that ties into your power app. Get user info -> get file from onedrive -> return file to pwoer app. Then use this statement as the item in the gallery, or use a button like you were before.

Was this reply helpful? Yes No
Lofy 6 on at

Like (1)

Report
Copy link

Link copied!

@developingteal Can you give some example statement, this is what I have been trying to figure out?
Should the respond to Power App send a get table, file ID, File Name, or something else?

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

Make sure to use office to get the user. I think you are having issues with pulling an actual file, and I think it is because the account attached is incorrect

Was this reply helpful? Yes No
Lofy 6 on at

Like (1)

Report
Copy link

Link copied!

I can see in the run history it finds the file and sends it to Power Apps. I don't use office to get the user because "List files in root folder" does that for me.

Was this reply helpful? Yes No
developingteal 392 on at

Like (1)

Report
Copy link

Link copied!

So is the data passing back to power apps correctly? Your issue would then lie with the display - which you mentioned before. If displaying the data is the issue give me a little more context. If it's a table something like a gallery would work, I just don't know what you are looking for

Was this reply helpful? Yes No