Using collection to update sharepoint column value

(0) Share

Report

Posted on by EriSto

137

Hi all,

I have a PowerApp for ordering items from our storage. It's based on a Sharepoint list (yes, I know lists are limited, but so is my PowerApp knowledge 😄 )

Anyways, I have everything working, but there is one last operation I need to incorporate:

I have a gallery view of all of the items (rows) that are “on order”. I also have a “checkbox”, so that the user can check off the items that are sent.

The items that are “checked off” are added to a collection.

Now, in my SharePoint list I have a “Yes/No” column which is “No” on default.

I am trying to get PowerApp to patch the selected items (forementioned collection) so that the “Yes/No” value is changed to “Yes” upon pushing a button.

I don’t understand how I can get PowerApp to use my collection of items to change the value of the selected items to “yes”

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report
There are a couple of things you need to do here:
Make sure when you add "checked off" records to your collection, you have also included enough other info that you can successfully LookUp that same record on your SP list afterwards. An ID value would be perfect
Once you can identify your record, you can use a Patch() statement to update the record in the SP list. The basic form of the Patch() will look something like:
ForAll(myCollection As aCol, Patch(mySPList, LookUp(mySPList, ID = aCol.ID), // This identifies the record to be updated { myColumn: // Put the column's new value here } ) )

Hope that helps,
Bryan

Was this reply helpful? Yes No