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
Microsoft Flow Update Field with Today
Microsoft Flow Update Field with Today
  • 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:
Update SharePoint List Field with today's date in Power Automate
  • 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.
Update SharePoint List Field with today's date in Power Automate
  • 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.

Microsoft Flow Update Field with Today date example

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:

Power Automate Flow Update Field with Today date

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

Update SharePoint List Field with today's date in Power Automate

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

See also  Power Automate Desktop Mathematical Operations

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.

Power Automate Flow Update Sharepoint List Field with today's date

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.
Microsoft Flow Update Field with Today date
  • 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.

Example to Update Field with Today date using flow

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:

Power Automate Flow Update Field with Today date

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

Example to Update Field with Today date using Power Automate flow

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

See also  How to Send an Email with Attachments from Local Folder using Power Automate?

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:

>