web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collection patch issue

Power Apps

Unanswered

Collection patch issue

(0) Share

Report

Report

Posted on by soycoreanito

6

I have two sharepoint lists and they have exactly same columns (ShPnt_TimeSheet ,ShPnt_TimeSheet_ThisMonth)

I use ShPnt_TimeSheet for the database (over 2000 rows) and I useShPnt_TimeSheet_ThisMonth for real time data (under 2000 rows)

so now I have problem with patching one collection from two sharepoint

I made this code

ForAll(Filter(Gallery5.AllItems,Checkbox1.Value),Patch(_col_timesheet_thismonth,{ID:ID},{ ....... }));

;

Patch(ShPnt_TimeSheet_ThisMonth,_col_timesheet_thismonth)

;

Patch(ShPnt_TimeSheet,_col_timesheet_thismonth)

is there any solution for me to patch collection to new sharepoint list?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @soycoreanito ,

First one is likely ambiguity - also structure below will be much quicker

Patch( _col_timesheet_thismonth, ForAll( Filter( Gallery5.AllItems, Checkbox1.Value ) As aPatch, { ID: aPatch.ID, ....... } ) );

Assuming all fields in the Collections are the same and they also exist in the List

Collect( ShPnt_TimeSheet_ThisMonth, _col_timesheet_thismonth ); Collect( ShPnt_TimeSheet, _col_timesheet_thismonth )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @soycoreanito ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation