Good morning, is there a way in a SharePoint list, after selecting an item and starting a workflow, to have the workflow activation date recorded in a specific column for that item? Thank you so much!

Hi @ Martin, Heidi (SE GP T SP PS) , You can add a date and time column to record flow activation date in your list. Add an " Update item " action in your flow and set the column use the function " utcnow() " like below. As per my test, every time I run the flow the time was recorded. If the answer is helpful, please click " Accept Answer " and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Capturing Workflow Activation Date in a SharePoint List

Accepted answer

AllenXu-MSFT 19,731 Reputation points Microsoft Vendor

2024-09-27T02:24:29.06+00:00

Hi @Martin, Heidi (SE GP T SP PS),

You can add a date and time column to record flow activation date in your list. Add an "Update item" action in your flow and set the column use the function "utcnow()" like below.

As per my test, every time I run the flow the time was recorded.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Martin, Heidi (SE GP T SP PS) 486 Reputation points

2024-09-27T05:01:54.8866667+00:00

Hello @AllenXu-MSFT

Thank you for the help – it's working wonderfully. 👍Now I have another question: Is it possible to create another workflow based on this FlowTime date, which specifies that a reminder message should be sent 14 days after the start of the FlowTime date? I'm considering how to implement this, but I would like to be able to trigger the workflow myself.

AllenXu-MSFT 19,731 Reputation points Microsoft Vendor

2024-09-27T06:00:32.93+00:00

@Martin, Heidi (SE GP T SP PS),

Thanks for your reply and we're delighted to hear that the posted issue has been resolved.

To send reminder message after specific days, I found this thread which may help: Send notification after 21 days of the date column.

I suggest you try this:

Using the "Compose" action of the Data Operation connector, define an addDays() math function to add 21 days to the Incident Date

Use a "Condition" action to outputs "Yes" if the current time is greater than the time outputted by step 1. Whenever it returns "Yes", send the notification. Whenever it returns "No", define the action as below: a) Use the "Do until" action and set the condition to the same condition used in the Yes/No "Condition" action b) Inside the "Do until" action, delay the next iteration until one day or half-day later using the "Delay until" action just to save action count. c) Outside and after the "Do until" action, define the send the notification action

By the way, Power Automate is not supported in Microsoft Q&A currently. If you still have any questions about this product, I suggest you go to the dedicated forum here:

Power Automate community. Experts and product team actively monitors questions there.

Thanks for your understanding:)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Martin, Heidi (SE GP T SP PS) 486 Reputation points

2024-09-27T06:12:13.7+00:00

Hi @AllenXu-MSFT
That's difficult, I'm not familiar enough with that. I will ask the community. Thank you for your kind support!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Capturing Workflow Activation Date in a SharePoint List

0 additional answers

Your answer