Power Platform Community Forum Thread Details

How to record static date changes in SharePoint List?

I have a SharePoint List that has a number of audits to be completed in a year. Each audit has a Status column with status choices of "Not started", "In progress", "Secondary Review", and "Closed". I want, when I edit an audit/item and modify the status, to record the date for that status change. I've already created 3 date columns to record the data (Date Started, Date in Secondary Review, Date Closed).

I was using the trigger when an item is created or modified and was using trigger conditions and Switch but the issue was every time a single item was modified, every other item in the list that had that condition was also updated. For example, if item #1 was modified and status was changed from "Not started" to "In progress", I'd like the Date Started column to record the date. But I don't want this to change in the future if this item (or if other items with the same status) were modified. I was running into the issue where tomorrow if I modified a different column for item #1, it would update the Date Started to the current day (even though the status wasn't changed). How would I prevent this and be able to create a Flow? Or do you think I should just utilize Power Apps?

Hi @ninos-shiba

Can you share with us your flow actions, albeit the below might help you to solve your situation? When a flow is triggered on an item changing you will have to use an action and in your case update item. This should then only update a specific item but you mention it is updating all items? Updating an item will then potentially trigger your flow again, therefore you need to be specific with trigger conditions.

I think the safest way to manage this is to have several flows with trigger condition and(equals(status, Not started),empty(datefield1)) and and(equals(status, In progress),empty(datefield2)) etc. This will mean the flow will always run once for each item where the datefield is empty. Once you update the date in that item, the trigger condition for empty(datefield) will not be met and the flow will not run on that item ever again.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Quick Links