Answered

Patch existing records and add new records

(0) Share

Report

Posted on by rahulswimmer

I have a collection in Powerapps for timesheet.

I get a selected week's timesheet and update exisiting rows with new values and on top of this i add new rows.

How do I patch the new values in existing records and add the new records ?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

MasterB 58 on at

Like (0)

Report
Hi,

you can update a row in a collection via a combination of Patch and Lookup . The second parameter of patch is the record for update. Like in a real table you need some kind of predicate you can uniquely identify the record for update in the DB this would be usually the PrimaryKey
So something like this:

Patch( // DataSource coll_YourCollection, // Record to update LookUp( coll_YourCollection, pk_filed = "whatever_id_that_fits" ), // Values for the cells to update { input: "NewValue" } )

To add a new record to the Collection you will just use the Collect function to append a new row...

Best
Jan ala MasterB

Was this reply helpful? Yes No
R2Power 18 on at

Like (0)

Report
Something like this should do the trick, probably a little bit different if your Collection is not the same format as your table:
ForAll(YourCollection, If(IsBlank(LookUp(YourTable, ID=ThisRecord.ID)), Patch(ThisRecord, {....}), Patch(Defaults(YourTable), {...})) )
You probably need to put

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (1)

Report

@rahulswimmer

Like @MasterB, but also to include new records if is the case:

ForAll(your collection,

Patch(datasource, Coalesce(

LookUp(datasource, column_id = collection_column_id),

Defaults(datasource)),{column_name1:value, column_name2:value}))

Hope it helps !

Was this reply helpful? Yes No
rahulswimmer 87 on at

Like (0)

Report

@gabibalaban @R2Power @MasterB I will definitely try that?

How do I find out the difference between existing collection and the new collection where new rows have been added, because I need to add the new records using defaults. So how do I detect if a record in collection is newly added ?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@rahulswimmer

If your original collection is based off of your datasource (i.e. you did a ClearCollect(yourCollection, YourDataSource))

Then it is even easier...

If you want to write back changes and new items:

Collect(yourDataSource, yourCollection)

will take care of new and existing records and updates all in one.

I hope this is helpful for you.

Was this reply helpful? Yes No
rahulswimmer 87 on at

Like (0)

Report
I was able to find a solution. It goes as follows:
// Update existing items in SharePoint ForAll( Filter(Col_PatchBack, Not(IsBlank(pbID))), UpdateIf( SharePointList, ID = pbID, { Hours: If(IsBlank(pbHours),0,pbHours), Date: pbDate, } ) ); // Finally add new items to SharePoint ForAll( Filter(Col_PatchBack, IsBlank(pbID)), Patch( SharePointList, Defaults(SharePointList), { Title: pbTitle, Hours: If(IsBlank(pbHours),0,pbHours), Date: pbDate, } ) );
You basically retrieve the ID of row for exisiting data and Patch it using UpdateIf, if ID exists it means you are updating existing item, if not its a new item.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@rahulswimmer

Since ForAll returns a Table, you are kind of wasting the Output of the table with that formula.

Consider the following that will execute quicker and will utilize ForAll for what it was intended for:

// Update existing items in SharePoint Patch(SharePointList, ForAll( Filter(Col_PatchBack, !IsBlank(pbID)), { ID: pbID, Hours: Coalesce(pbHours, 0), Date: pbDate, } ) ) ); // Finally add new items to SharePoint Collect(SharePointList, ForAll( Filter(Col_PatchBack, IsBlank(pbID)), { Title: pbTitle, Hours: Coalesce(pbHours, 0), Date: pbDate, } ) );

Was this reply helpful? Yes No