How to Update SharePoint List Field with today’s date in Power Automate?

In this Microsoft Power Automate tutorial, we will discuss how to update SharePoint list field with Today’s date in Power Automate.

Here, I will show you two examples, in one example, we will update the SharePoint list field value with today’s date, and in another example, we will update list column values with Today’s date + 7 days.

How to Update Sharepoint List Field with today’s date in Power Automate

Here we will see how to update Sharepoint List Field with today’s date using Power Automate flow,

Example:1

In this example, we will use the Products Orders SharePoint List.

• Product ID – Default title field
• Product Name – Text field
• Product Color, – Choice field
• Quantity and Total Price – Number Fields
• OrderedDate – Date Field
• Mode of Payment – Choice field
• Product Delivered status – Choice field
• Current date – Date field

• Now we will create a flow to update a field called current date with today’s date value, For that login to the Power Automate and create an instant cloud flow.
• Enter the flow name and click on the create option below:

• Select the +new step and add the “Get items ” action to update multiple list items with today’s date value based on the list item id.
• Provide the SharePoint site address and SharePoint list. Here I have selected my Products Orders list.

• Now select an Update item action and provide the required fields like SharePoint site address, List Name, ID, and Title.
• In the current date field pass the below expression to update the field with today’s date under the expression tab.

formatDateTime(utcNow(),'dd/MM/yyyy')

It automatically applies to apply to each action, to update multiple list items with today’s date value.

Click on the save and test option to save our flow. To run the flow select the Run flow option. Once our flow ran successfully like below:

We can see our SharePoint list current date field is updated with today’s date value (whereas today’s date is 03/07/2023 ).

This is how to Update Sharepoint List Field with today’s date using Power Automate.

Example:2

Here we will how to update the Sharepoint List date Field using Power Automate.

In this example, we will use the below list. Then we will calculate the Estimated delivery date based on the order date(highlighted in red) using Power Automate flow. The estimated delivery date will be Order date + 7 days.

To accomplish this, follow the below-explained steps:

• Create an instant cloud flow to trigger the flow manually.
• Select the +new step and add the “Get items ” action to update multiple list items with a date field based on the list item id.
• Configure the SharePoint site address and SharePoint list. Here I have selected my Products Orders list.

• Now select an Update item action and provide the required fields like SharePoint site address, List Name, ID, and Title.
• In the Estimated Delivery date field pass the below expression to calculate values based on the Order date value.
• So we use the Add Days function to calculate 7 days based on the Order date value.

addDays(items('Apply_to_each')?['OrderedDate'],7, 'dd-MM-yyyy')

Where,

• add days -> function name
• OrderedDate -> Time stamp
• 7 -> days
• dd-MM-yyyy -> Date format

It automatically applies to apply to each action to update multiple list items with the current date value.

Click on the save and test option to save our flow. To run the flow select the Run flow option. Once our flow ran successfully like below:

We can see the estimated date field is updated by adding 7 days from the ordered date field in the Products Orders SharePoint list.

This is how to update the Sharepoint List date Field using the Power Automate flow.

Conclusion

In this Microsoft Power Automate tutorial, we have discussed how to update the SharePoint list field with Today’s date value. In another example, I have also explained, how to update the SharePoint list field value with today’s date + 7 days.

You may also like:

• create an array from an Excel table using Power Automate
• Create an HTML Table from Excel in Power Automate
• Save Microsoft Forms Responses and Attachments to SharePoint Lists using Power Automate
• Apply Filter Between Dates in Power Automate
• How to Send an email with options in Power Automate?