Power Platform Community Forum Thread Details

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.

Categories:

Collect PowerApps Data to SharePoint Error: No permissions