Answered

Update a column in a Collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm trying to assign the value of my MasterID for all items of my collection at the moment I patch my collection data in my SharePoint list.
But I don't know how I should proceed.

This is the code I save data to my list:

SubmitForm(SharePointForm1);;
If(
 CountRows(CollectionObjUp) > 0;
 Patch(
 'Plantilla Objetivos';
 CollectionObjUp
 )
);;
Clear(CollectionObjUp)

Maybe can be done using some kind of "Update" function for change the value of my columns?

SubmitForm(SharePointForm1);;
Update(CollectionObjUp;MasterID=SharePointForm1.LastSubmit.ID);;
If(
 CountRows(CollectionObjUp) > 0;
 Patch(
 'Plantilla Objetivos';
 CollectionObjUp
 )
);;
Clear(CollectionObjUp)

Many thanks in advance,

Marina.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous you can use the UpdateIf function.
It would be better to move all the code you have after the SubmitForm() to the OnSuccess of SharePointForm1.
Your formula will be,
If(CountRows(CollectionObjUp) > 0; UpdateIf(CollectionObjUp;true;{MasterID:SharePointForm1.LastSubmit.ID});; Patch( 'Plantilla Objetivos'; CollectionObjUp ) );; Clear(CollectionObjUp)

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous You can also try
ForAll( CollectionObjUp As collection,collection.MasterID=SharePointForm1.LastSubmit.ID);;

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Did it work?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
It didn't.
It keeps the MasterID = 1, it does not change to the ID value of my master list.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Can you show me the code and also the contents of CollectionObjUp after the code runs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is my form screen:
Once I save, (So SharePointForm1 Success, with the code you provided me), my second list looks as follows:
MasterID always keeps 1.
What I want is save the items with the ID of my Master Form/List.

Many thanks for your help.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Display the value of SharePointForm1.LastSubmit.ID in a Label and see what it is.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It keeps in blank, just when I press save it shows the same number as "SharepointIntegration.SelectedListItemID" but only for a milliseconds.

After saving, I enter again to the item list and then it shows the ID of my master list as is shown:
But in my 'Plantilla Objetivos' list the items are saved with MasterID = 1.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous If SharePointForm1.LastSubmit.ID is returning a null something went wrong with the Submit. You need to sort out that first.

Was this reply helpful? Yes No