Power Platform Community Forum Thread Details

Hi Everyone,

I am stuck trying to figure out how to get a collection of data from Powerapps into a sharepoint list. I've looked at and tried a handful of patch/forall statments and havent figured it out yet.

My scenario is I have a collection (LocationCount) containing two columns, 'JobLocation' and 'CompletedAssessments'. I would like to patch this data into a sharepoint list (JSAQuota), which contains columns 'JobLocation' and 'CompletedAssessments' along with other columns for data, quota value, etc.

Where I get stuck is the LocationCount collection may only contain one or two rows of matching JobLocations compared to the entire Sharepoint list column JobLocation. How can I patch the 'CompletedAssessments' number into the sharepoint list when the corresponding Joblocation values in the collection and sharepoint list values match?