You’re offline. This is a read only version of the page.
I’m trying to extract a table from an Excel Online file saved in Sharepoint to Power Apps. In my use case I will be extracting similar tables from different Excel Online files saved in Sharepoint (depending on a user’s selection in the gallery view) so importing a single file’s table data won’t work in the long run.
I tried creating a Power Automate Flow within Power Apps:
1.(Sharepoint connector)
-Get file content using Path
-Entered Site Address
-Used Dynamic Content for File Path -> Ask in PowerApp
2.(Excel Online connector)
-Get tables
-Entered Location
-Entered Document Library
-Used Dynamic Content for File -> Ask in PowerApp
3.(Excel Online connector)
-List rows present in a table
-Entered Location
-Entered Document Library
-Used Dynamic Content for File -> Ask in PowerApp
-Used Expression: first(outputs(‘Get_tables’)?[‘body/value’])?[‘Name’]
4.Respond to a PowerApp or flow
—-
In Power Apps, the expression for ‘OnSelect’ of a button on Screen2:
Fx: ‘PowerApp->Getfilecontentusingpath,Gettables,RespondtoaPow…’.Run(Getfilecontentusingpath_FilePath,Gettables_File, Listrowspresentinatable_File)
For
Getfilecontentusingpath_FilePath (I tried using a variable which I set from Screen1= varFolderPath, where on that screen I created a gallery to show documents in a Sharepoint document library)
Gettables_File (I tried using a variable from Screen1= GalClientData.Selected.’File name with extension’ )
Listrowspresentinatable_File (I am stuck on how I should proceed with this variable)
Ideally I would like the table from the Excel Online file to show up in a Gallery/Table view in Power Apps. If possible I will then set variables on the cells within the table itself that allow the data to automatically populate into another screen with a form view. (Hoping that this can be a dynamic feature for when other tables from other Excel Online files are selected) The table won’t contain a large set of data too.
I’m very new to the Power Automate/Apps world and after scouring the web I haven’t been able to find something similar for my use case, so I would greatly appreciate any advice and workarounds that anyone provides. Thanks!
Hi @bellads28 ,
You can use Excel Online connector, pass file identifier to your flow and get the table dynamically:
After the first run, copy the outputs and paste in Response action, generate JSON schema and convert it to collection, and then pass to your App collection.
However, using collection as data source of a Form could not get its fields in the Form, you can use custom Cards and add controls to display field values. This could not use for updating values to dynamic data sources because you need to Patch with static connections' name in the function, or SubmitForm to a static data source of the Form.
Best regards,
Share
Report
All responses (
Answers (
791
