Updating a column in a sharepoint list using Flow

[Raou]

Hello community;

I have 2 columns in my sharepoint called "Agree" and "disagree" and I am creating a Flow to update/increment the columns anytime a user click on "Agree' or "disagree" Buttons in Powerapps.

I tried to put this function. "add(TriggerBody()?['Agree'],1)" for Agree and "add(TriggerBody()?['Disagree'],1)"

However I am getting error.

Any idea how to make this work.

Thank you.

[eka24]

This is a Power Automate question. Kindly post it on the Power Automate community your solution.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-xida-msft · Accepted solution]

Hi @Raou ,

Regarding the screenshot you mentioned, I think there is something wrong with the value provided in Agree field and Disagree field in your "Update item" action.

I assume that the Agree field and Disagree field are both Number type field in your SP List, you should provide a valid number value for the Agree field and Disagree field in your "Update item" action, but you remain a '0' before the add(...) expression in Agree field and Disagree field.

On your side, please remove the '0' before the add(...) expression in Agree field and Disagree field of your "Update item" action.

then save your flow, then try it again, check if the issue is solved.

Regards,

[Raou]

Hello @v-xida-msft 

Thank you for the feedback.

yes it works later after I removed the 0s.

However, I am facing an issue after that with an infinite loop.

when I click on the "Yes" or "No"  buttons in my PowerApps , the number in "Agree" or "Disagree" SharePoint columns keeps incrementing.

Could you please advise.

I want to make sure when a user clicks on the "Yes" or "No" button in my PowerApps, the number can only increases by 1.

Thank you.