Unanswered

Patch Collection

(0) Share

Report

Posted on by venky232

i have collection(selected records from Gallery) in powerapps which contains 20 coloumn, now i want to patch few coloumns from collection to Sharepoint list. how to patch the code?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

madlad 2,637 Moderator on at

Like (0)

Report
I'm assuming your SharePoint list and collection are set up similarly. To patch items from a collection as new items, you could try something along the lines of
ForAll( *YourCollection*, Patch( *YourSPList*, Defaults(*YourSPList*), { Value1: ThisRecord.Value1, Value2: ThisRecord.Value2, Ect. } ) )
To update records instead of creating new ones, specify the record to update instead of using Defaults(YourSPList) in your patch statement.

For more info on Patch, see The Documentation

Hope this helps!

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

its working but if collection is empty and when user click submit button , it is creating empty record in SP list. how to avoid this?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Try something like:
If( !IsEmpty(*YourCollection*), Patch(...) )

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

ForAll(
MyCollection,
If(
!IsEmpty(MyCollection),
Patch(
'ABC',
Defaults('ABC'),
{
Title: ThisRecord.'Title'
})))

still showing empty record in SP list

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (2)

Report
Try:
If( !IsEmpty(MyCollection), ForAll( MyCollection, Patch( 'ABC', Defaults('ABC'), { Title: ThisRecord.'Title' } ) ) )
Please also confirm that you have no records with a blank title in the collection-
This could be accomplished using something like, just prior to your Patch statement:
RemoveIf( MyCollection, IsBlank(Title) )

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

its working ,thanks for your Support.
one question, when user click submit button twice ,same selected records patching twice in list

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
that makes sense, as it's likely still selected- if the collection is only being used to patch to the SharePoint list, you could clear it after the patch statement runs, which should solve this.

If you can't clear the collection quite yet, but you never want to have duplicate records in the list, you could also include something like:

If( !(ThisRecord.Title in 'ABC'.Title), Patch(...) )

in your ForAll, just to ensure duplicates don't patch.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

again got some issue, here it checking duplicate record only 1st item, if i going to patching mutiple records.

RemoveIf(MyCollection, IsBlank('Title'))
If(!IsEmpty(MyCollection),
ForAll(
Filter(
MyCollection,
Not(ThisRecord.'Title' in LookUp('ABC', 'Created By'.Email = User().Email, Title))
),
Patch('ABC', Defaults('ABC'), { Title: ThisRecord.'Title' })
)
)

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report
If I understand correctly, your records are only being compared against the user's first record when patching?
I think the problem lies in the:
Filter( MyCollection, Not(ThisRecord.'Title' in LookUp('ABC', 'Created By'.Email = User().Email, Title)) )
LookUp only returns the first value it finds, so it will only compare your values to the first one created by the user. Try switching the code snippet above to something like:
Filter( MyCollection, Not(ThisRecord.'Title' in Filter('ABC', 'Created By'.Email = User().Email).Title) )
Please note I haven't tested this code so you may have to play around with it a little bit.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

its working now, thanks for Support

Was this reply helpful? Yes No