Unanswered

How to patch multiple selected items' ID to a single item in sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have created a form with a collection of gallery in the data card which shows other list data:

I want to let user to choose the items and patch the selected items' ID to sharepoint list, but I'm not sure what should I do for the submit button and power automate.

I created a gallery(Gallery3) for all the selected items in the table.

This is my current formula for submit button:
JSON(
ShowColumns(
Gallery3.AllItems,
"ID"
),
JSONFormat.Compact
)
);

these are my current power automate:

I tried to select 2 items from the table and submit. However, it created 2 items instead of 1 and the ID format is not what I want, I want to have 73, 76 in the field.

Moreover, after the ID is submitted, I also wish to show the details of selected items in view mode on powerapp for approver to review, but I'm not sure if just submitting ID is enough to show all the details in the table. Please give some advice on this too.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

To update only 1 row you will have to do this update item outside apply to each loop. You can keep the join action inside the loop, but update the item outside the loop.

Now coming to the 2nd part. You want 73, 76.

For this just use ID instead of using body in the join action.

Fix these issues, then we can move forward with other issues. I hope this helps 🙂

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,

Thanks for the reply. If I use ID instead of body, this error shows up.
Also, how can I do the update item outside the loop if I have to get the create item ID and output of join from the loop?

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Use a compose action in your flow. Add the data you are getting in it.

And paste the screenshot here. Hide the personal details. I want to see how the Id part is coming. If you don't want to add screenshot copy whatever you are getting and then replace the personal details with some other value.

See for joining you are using apply to each 3.

But to update it use it inside apply to each 2 loop only.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,

This is my current flow, update item is not necessary if i can get the joined id beforehand.

My error details for this flow:

Thanks for your help and hope to hearing from you soon.

Was this reply helpful? Yes No