Answered

Adding a value to sharepoint

(1) Share

Report

Posted on by ZackS

112

So just to summarize it,

I need to make a flow where when a user submits a form, if a specific answer is selected (radio buttons) it will add 1 to a sharepoint list column.

I've been struggling with this for the whole morning.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

David_MA 14,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Can you show what you have so far in your workflow. And the column you are adding 1 to, is it for the same item every time? If not, how does your flow know which item it needs to add 1 to?

Was this reply helpful? Yes No
ZackS 112 on at

Like (1)

Report
Copy link

Link copied!

Hi @david MA, Sorry I've actually deleted the flow to recreate it, Basically what I need is the following

A form is submitted
it gets the the response details
based off of the employee's ID it'll update their row based on the occurrence, The occurrence we're working on is just checking if someone is absence, Basically if it already has a sharepoint value which should be nil if they've never been entered in before, it'll just add Plus 1 to the value

Was this reply helpful? Yes No
David_MA 14,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Ignore: getting used to how the new forums work.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
To do what you want, I would do the following:

Update the SharePoint list so that the default value where you want to increment the value is zero. Also, make sure the field is a number field and set it to zero decimal places.

Set the field that stores the employee's ID to make it required and enforce unique values. This will ensure each employee can only be entered in the list once. I would also suggest that you index this column in your list.

In your workflow that triggers when a form response is received, add a variable (we'll call it Plus 1) to store the calculation for the "add plus 1 to the value" of integer type.

Add a Get items action and point it to the SharePoint list to update. I assume that in the form response, there is a question that asks for the employee ID. User a filter query to filter it to where the employee ID in the SharePoint list equals (eq) the value from the form response.

Add a condition and use a length expression to check if one row has been returned from the Get items action.

If yes, on the yes side of the condition add an apply to each action. This is required when you use the Get items action since it returns an array, but since you have configured your SharePoint list to require unique employee IDs, it will only update one row.

Add a set variable action and set the Plus 1 variable with the current value from the SharePoint list.

Follow it with an increment variable action and increment it by 1.

Add an update item action configured to your SharePoint list and use the variable to update the corresponding value in your list. You could send an HTTP request to SharePoint to do this, but that is more complicated. But once you know how to update an item with an HTTP request it often makes things easier than an update item action

If no, on the no side of the condition you can create an item in your SharePoint list to add the new employee ID and set the initial value of the count to 1.

Was this reply helpful? Yes No
Verified answer

ZackS 112 on at

Like (1)

Report
Copy link

Link copied!

Hey David, I just figured this out using fx

I did this:

if(

equals(item()?['SHAREPOINTCOLUMNNAME'], null),

1,

add(item()?['SHAREPOINTCOLUMNNAME'], 1)

)

Thanks for your help!

Was this reply helpful? Yes No