Power Automate update SharePoint list increment integer field

In this Power Automate tutorial, we will discuss how to update the SharePoint list increment integer field using Microsoft Flow.

We will see an example of Microsoft flow or Power Automate update SharePoint list increment integer field.

Update SharePoint list increment integer field using Power Automate

Here we will see how to update the SharePoint list with increment integer field using Power Automate or Microsoft Flow.

So for this example, I have created a NewsletterBenefits list, from this list we will use the Title Id which is a number/integer field.

So in the SharePoint list, we have a list of items, and every day we want to send one post to the Team channel.

From the SharePoint list, it will continue to loop through all the items in the SharePoint list, no matter how many items are there. Then we will post every day the content of one item in Microsoft teams.

So here those items get posted in the Teams, those item identifiers i.e. Title id will get updated with plus 1 in the SharePoint list.

Steps for Microsoft flow update sharepoint list increment integer field

Here we will see the steps for Microsoft flow update SharePoint list increment integer field.

Step 1: Create a SharePoint list

I have already created a SharePoint list, called BenifitsNewsletter, it contains 3 columns with column types.

ColumnColumn Type
Title idNumber
TitleSingle Line of Text
DescriptionMulti-Line of text

So in this SharePoint list, I have added three items.

microsoft flow update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

Once the SharePoint list is ready, we will create a Flow.

Step 2: Create a Flow in Power Automate

To create a Flow, log in to Power Automate, then click on Create and select Scheduled Cloud Flow.

microsoft flow update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

Now provide the flow name, and then set the date and time and frequency as Every day.

microsoft flow update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

Step 2: Initialize 3 variable

Now we will initialize 3 variables, i.e. MaxTitleid, MinTitleId, NewTitleId, to store the maximum current value from the Titleid Field, to store the min current value from the Title id field and hold the MaxTitleid +1 value and also replace the existing value of the Title id field in SharePoint list when that item gets used.

So, click on the Next step and select Initialize variable action, and then set the variable name type as float and value as 0.

Power automate increment integer field
Microsoft flow update sharepoint list increment integer field

Also, read How to get email address from name in Power Automate

Step 3: Get Max Title id value

To get the Max title id value from the SharePoint list items, click on the next step and then select Get items action.

Then Provide the site address and list name of your SharePoint list.

Then click on Show advanced options, in the OrderBy field set the Titleid desc, to get the max number. And then set the top count as 1 like the below screenshot.

Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Step 4: Set the Max value in the MaxTitleid

To set the Max value we get from the previous step, click on the Next step and then select Set variable action.

Then select the variable, MaxTitleid, and in value select Title id from the dynamic content. When you set the value it will automatically add the Apply to each action.

Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Step 5: Increment value with +1

Now in this step, we will do the operation i.e. MaxTitleID + 1, store it into the NewTitle id variable.

So, click on the Next step and then select the Increment variable action, then select the variable name as NewTitleId, and then set the value with the below expression:

add(variables('MaxEventId'),1)
Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Step 6: Get the lowest value

To get the Lowest value from the same SharePoint list items, click on the Next step and then select the Get items action, then provide the site address and list name of the SharePoint list.

Then click on the Show Advanced option, and then set the order by as ascending i.e. TitleId asc to get the lowest id value. Then set the top count as 1.

Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Check out, How to call a flow from another flow in Power Automate

Step 7: Save the minimum value in the variable

To save the lowest value get from the previous step, so click on the Next step, and then select Set variable action.

Then in the name Field, select the MinTitle variable, and in the value set the Title id from the dynamic content and it will automatically add the Apply to each action.

Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Step 8: Post the information on Teams

In this step we will Post the information on Teams, we will share the SharePoint list items, which Title id is lowest.

So, click on the Next step and then select the Post message in a chat or channel action. Then provide the post as, post in, Team, Channel and set the message from the dynamic content, it will automatically add Apply to each action.

Power Automate update sharepoint list increment integer field
Power Automate update sharepoint list increment integer field

Step 9: Update item with new value

Now we will update the item that we used in the previous step i.e. post information on teams and then replace the existing Titleid value, with the variable NewTitleId(contain MaxTitleid +1).

Now we will use the lowest TitleId value from the SharePoint list, and then we will replace the Title id value with the highest value and update the item in the SharePoint list.

So click on the Next step and then select the Update item action and then provide the site address, list name and then provide the id value, it will automatically add the Apply to each action. Next set the Title and in Title id value

Power automate update increment value
Power Automate update sharepoint list increment integer field

Once your Flow is ready you can run the Flow manually

Read Power Automate create table

Step 10: Run the Flow

Now the flow will run every day, and for testing purposes, we will trigger it manually. So click on save and run the flow manually. You can see your Flow ran successfully

Power automate update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

Next check the team channel of your site you will receive a message.

microsoft flow update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

At last, you can see the lowest item gets updated with the highest value in the SharePoint list.

microsoft flow update sharepoint list increment integer field
Microsoft flow update sharepoint list increment integer field

This is how Microsoft flow updates the SharePoint list increment integer field.

Related Microsoft Flow tutorials:

In this Power Automate tutorial, we learned how Microsoft flow or Power Automate updates the SharePoint list increment integer field.

>