Unanswered

check if the Collection already contain and item before patching it to prevent saving it twice

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following code, to Loop on all the items inside a collection named "colSItem" and patch them to a SharePoint list named @"SNMItems":-

but i want to only patch the items that are new to the collection... so how i can define to only patch the item is its id does not exists inside the collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@johnjohn123

Your collection should always have the same schema as the records that you wish to apply them to - or at least as close a possible.

So, if this is a collection of SharePoint records, then the ID will either have a value (existing) or be Blank() (new).

With that combination, using a formula such as this:

Path(yourDataSource, yourCollection)

will create new records and update existing records.

Note: the above formula implies and exact match to the records.

If the records do not match, then formulas like this will be equivalent:

Patch(yourDataSource, ForAll(yourCollection, {ID: ID, someColumn: someCollectionColumn } ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayessorrt i did not get your reply.. where you are checking if the item Id already exists inside the collection?

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

Like (0)

Report
Copy link

Link copied!
@johnjohn123

Sorry, the formula I provided would create new records and update existing.

If you are only concerned with the New items, then filter your collection by blank ID's.

And if you're creating new items only, then you can use the Collect function.

ex.

Collect(yourDataSource, Filter(yourCollection, IsBlank(ID)))

Or for the other:

Collect(yourDataSource, ForAll(Filter(yourCollection, IsBlank(ID)), {ID: ID, someColumn: someCollectionColumn } ) )

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes now the formula i need should work for new items + updating items.. for example when i create a new master record and i enter new child records.. on other scenarios i might edit the master record and do not add any child.. in the later approach i do not want to have duplicate items inside the child.. did you get my point?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes i tried your formula and still duplicate child record will be created incase i update the master record! any advice please?

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

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Can you provide the formula you are now using as well as the formula you use to populate the collection you are using?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

To Populate the collection with a new item i am using:-

and to Patch the collection to SharePoint i am using:-

Thanks

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

Like (0)

Report
Copy link

Link copied!

@johnjohn123

You need to change the Defaults function to specify the DataSource name - not the collection name.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes can you describe your point in more details? now the code to add a new Item to the collection is working well.. this code, is adding a new item to the collection without any issues

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

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Yes, but you are patching the Defaults and the hand-written record to your collection. Defaults is returning the default record of the *collection* not your datasource. Therefore the collection will NOT have the schema of the datasource record, but of the collection - which has no schema.

You need to reference the Datasource in Defaults, otherwise your collection will not have an ID column in it.

Patch(colSItems, Defaults(yourDataSource), {....

Was this reply helpful? Yes No