Unanswered

Conditional Date Stamp Column in Sharepoint 365 List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need to build a date column that will capture when a Choice Field (Status) is marked as complete.

The goal is to capture the date that the item's status changed to "Complete". This field can't be editable, nor can it change once entered.

Does anyone have an idea regarding the best way to go about this? I have seen many examples for sharepoint 2013 and 2010, but nothing so far for 365.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

I don't think this is possible through Microsoft Flow.

Currently Microsoft Flow doeesn't support single field trigger, this has been submitted as an idea:

Trigger a flow when a specif SharePoint list field is updated.

To update a field value, Microsoft Flow would require the current user has the full edit permission of the field.

You may consider ask this question under the SharePoint online forums, see if experts there could share any helpful solutions:

https://social.technet.microsoft.com/Forums/en-US/home?forum=onlineservicessharepoint

Regards,

Michael

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Maybe you can apply the following workaround: instead of manually change status to "Completed", you can create a flow to be manually invoked once the target item is selected. Upon execution, this Flow would change item status to "Completed", calculate the date and store it. As @Mike2500 explained in another thread:

In a SharePoint list that is set to use the modern UI, select an item, and then click Flow --> create a flow. This will bring up a list of templates on the right, including "create a custom action for the selected item".

Then, everytime you select an item, and then click Flow, you will see this new Flow name displayed, just click on it and it will be executed.
Hope this helps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Flow does support triggers within choice fields as I have quite a few of them working at this time. I just don't know how to say:

If Choice = "Completed" --> populated today's date into Date Completed field.

I would also add in another field (flag field/ boolean) to notate if the Date Completed Field has value or not and use that as a condition for the above. That way once the date was captured once, it wouldnt update every time the item was updated, just once initially.

I hope that makes sense.

Was this reply helpful? Yes No