You’re offline. This is a read only version of the page.
Hi everyone,
I'm trying to collect All Items from my DataTable "Gallery2" (PowerApps) to my Excel-table "Tabelle1" (SharePoint).
Formular:
ForAll(Gallery2.AllItems; Collect(Tabelle1; {Auftragsnummer: Auftragsnummer.Text; Artikelnummer: Artikelnummer.Text}))
I already connected my App with the Excel. My App recognizes the Excel-Table.
However, it tells me that PowerApps doesn't have permissons to edit this Excel-Table.
I am the Owner of the whole SharePoint-Site incl. SharePoint-Lists and the Excel-File.
So why can't I Collect all the Items?
Do I have to set extra permissions for PowerApps?
I would be very glad if you could help me!
Thank you very much!
PS: The Formular works with Collections within PowerApps. There seems to be no problem with it.
@Anonymous
From what I understand it is not currently possible. If you want Excel as your datasource you'll have to store it in OneDrive and use that connector instead. Check out this idea link below and give it a vote if you want to have the ability to use Sharepoint/Excel. Its currently Under Review so every vote counts. MS listens to the user community.
Here's some more discussion on the topic.
Share
Report
All responses (
Answers (
29,989
