Hi @CollabTechie, one way to do this - there might be more elegant ways - is shown below.
The overall flow looks like this and we'll then look act each component:
I've manually triggered the flow then the first action is the Excel List rows present in a table.
Next add an Apply to each control, and for each value returned we add a SharePoint Get items action. But we only want to bring back the 1 item in our SharePoint list where the email address (in my Title column) is equal to the Email recorded on the form response. So add a filter query of Title eq '{Email}' where email is selected from the dynamic content. Making sure you put it inside single quotes.
Next add another Apply to each control and select value from the Get items section of the dynamic content.
Inside that apply to each add:
1) a Compose control to get the current total in the SharePoint column;
2) a Compose control to get the Total Points for the user from the form. You need to note that this is brought into the flow as text, not a number. So then;
3) add a Compose to turn it into an integer using the expression int(outputs('Compose_txtPointsToAdd'))
Next add another Compose control to do the addition. The expression is add(outputs('Compose_CurrentScore'),outputs('Compose_intPointsToAdd'))
Finally, add a SharePoint Update item action and in the Total column select the output from the Compose Addition.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
