Unanswered

How do I save data from Collections to SharePoint

(0) Share

Report

Posted on by Pariyes

I want to save data from Collections to SharePoint by pressing the save button once.
By saving data from every row of Collections into SharePoint.
What code do I need? Please help me.

Picture 220407-1 is the data in Collections.

Picture 220407-2 is a window showing data in Collections.

Picture 220407-3 shows SharePoint that wants to save data from Collections.

Could you help me please.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Adrian_Celis 1,652 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Pariyes

You can use the ForAll function to loop through each items in your Collection. Try the code below:

ForAll(YourCollectionName, Patch(YourDataSourceName,Defaults(YourDataSourceName), { L2CodeMat: L2CodeMa..., L2DescriptionOR: L2DescriptionOR, L2LeadTimeOR: L2LeadTimeOR, L2MOQ: L2MOQ..., L2QtyOrder: L2Pqty..., L2UnitOrder: L2Unit..., XL2PriceOrder: L2Price..., L2Stock: l2Stoc... } ) );

Note: Some column names have an ellipsis (...) because I could not see the columns name.

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Pariyes
Assuming your columns in the collection match the columns in SharePoint you can simply do this

Collect( DATA-P_MALOX_Thailand, L2OrderMat)

Was this reply helpful? Yes No
Pariyes 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks You, I'll try the method you suggested. then i will update again.

Was this reply helpful? Yes No
Pariyes 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks You, I'll try the method you suggested. then i will update again.

Was this reply helpful? Yes No