Unanswered

Save A Collection into a List in Sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey All,

How can I safe my entries in Powerapp in a List in Sharepoint? I just know how to make a Collection, but I want it in Sharepoint. Can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

PavanKumar 479 on at

Like (0)

Report
Copy link

Link copied!

Hi Fatih1

There are multiple ways to do it. Following links help you achieve it.

https://powerusers.microsoft.com/t5/General-Discussion/Save-data-to-SharePoint/td-p/152242

https://powerusers.microsoft.com/t5/General-Discussion/Save-PowerApp-data-to-SharePoint-list/td-p/44058

Let me know if that doesn't answer your question.

if this answers your question please mark it as verified and give thumbs up
Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to save a Collection data back to a SP list data source within your app?

Based on the needs that you mentioned, I think the combination of ForAll function and Patch function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following:

ForAll( YourCollection, Patch( 'YourSPList', /* <-- represents your SP List data source */ Defaults('YourSPList'), { Column1: YourCollection[@Column1], Column2: YourCollection[@Column2], Column3: YourCollection[@Column3], ... } ) )

Please also check and see if my response within the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Saving-a-Gallery-to-a-SharePoint-List/m-p/158922

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-xida-msft,

the Syntax was exactly what I needed, but now I get an Error, which you can See in the Screenshot.
Error: The Type of Title is not the expected Type "Text". Found "Text".

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ，

Based on the formula you provided, I think you have some misunderstanding with above formula.

When you use Patch function inside the ForAll function, you should reference values from the collection for the columns in your Patch function rather than reference values from other place.

More details about the Patch function and ForAll function, please check the following video for more details:

https://www.youtube.com/watch?v=MclJ_O9HvJQ

Please modify your formula as below:

ForAll( BesucherCollection;
Patch(
Besucher;
Defaults(Besucher);
{
Title: BesucherCollection[@ID]; /*<-- If you type ID directly here, PowerApps could not recognize the ID column is from Besucher SP list or the BesucherCollection */
...;
...;
FirmaBes: BesucherCollection[@firmabes]
}
) )

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft ,

I tryed it, but they show me the same Error.
Error: the type of this argument does not match the expected type "text". found type "table"

If I ignore the Line -> Title:BesucherCollection[@ID]; then it doesnt show me a Error.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Currently, I could not reproduce your issue on my side. Please check if you have specified proper column name within the '{}' part of your Patch function, and provide a proper value (referenced from the BesucherCollection) for these specified columns.

Based on the error message that you mentioned, it seems to tell that there is something wrong with the values you provided for the arguments within the '{}' part of the Patch function. Please make sure you have provided proper values (referenced from the BesucherCollection) for these specified columns

Best regards,

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you solved your problem?

If you have solved the Problem with your Patch function, please consider click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No