Power Platform Community Forum Thread Details

Good morning.

I am attempting to patch a SharePoint List to update records, not create new ones. The idea is:

User selects a Department - and then the Unit/Project list populates. Once the user selects a Unit/Project, a collection is generated based off of those 2 filter criteria's, and then the collection is displayed on the lower half of the screen. The user may assign a "Cost Center" to these unit/projects, which successfully adds them to the sharepoint list. These get added with a blank Quantity and Cost amount. The idea is the user would enter in the quantities for all assigned cost centers, and then select "Update Quantities" - which would in turn, go update those specific records in the sharepoint collection list.

To my understanding, I would update the collection with the changes, and then send that collection to update my list.. But I seem to be running into issues. I imagine the collection could be initially generated on the "Update Quantities" onselect, and I could display my gallery via a regular filter?

My collection is called: ChargesColl

Columns attempting to patch: Quantity and Costs.

Thank you in advance for all of your assistance.