
Announcements
I tried to create power apps for approval of documents list, or PRJ list. for this i have
then i have this form who need to choose 'PRJ list document' that contain in Document library. then depen on what you choose, next you choose what 'document' you want on excel tabel coloum document.
i can select or get all the file name that contain in Document library, but i cant open those specific selected file and get the table data out of it.
i know it kinda hard to get but maybe this pic can help.
is it possible tho? or is there any alternative way?
See https://powerusers.microsoft.com/t5/Building-Power-Apps/Connect-to-Sharepoint-Excel/td-p/506064 . Excel is a terrible data source anyway, particularly if you have multiple users for your app. I recommend storing the data in SharePoint or even Dataverse if you can afford it.