Create a flow

(1) Share

Report

Posted on by stormyg241

Hello, I need to create a flow from Microsoft list using Yes/No column to update the date column to the current date. However, I have 3 choice columns that are all required (needs to be) but they are multi-select choice column.

Any help would be welcomed! Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @stormyg241

There is not clear enough details here to help you. Please provide a complete explanation of the business logic you need based on the flow you have, or at least, based on how you want it to work.

Think of it as steps, write them out please. :-)

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

You haven't provided many details but you can use this tutorial to show you how to create the flow Power Automate Tutorials [Beginners + Advanced] - SPGuides.com

The Yes/No requirement would require a condition action. You haven't indicated the relevance of the choice columns but here is another reference source on managing choice columns How to Get SharePoint Choice Values in Power Automate? [With Multi-Select Choices] - Enjoy SharePoint

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,334 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@stormyg241,

Lets break the solution.

Update the date column

When Item is created or Modified action use this as trigger condition - @not(equals(triggerOutputs()?['body/Created'], triggerOutputs()?['body/Modified'])) this will allow the flow to trigger in modified case only.

However Microsoft also came up with action - When an item or a file is modified you can also use this as well .

Intialize variable (array) to handle the Multi choice column.

Append the multi choice value to array variable using (append to array) action.

for date setting - utcnow().

But one thing, if we are updating these items from power automate based on the modification, after our update the flow might be trigger too so trigger should be based on some column in the list to avoid this circular looping (i.e. by default value should be set to In-Progress and when updated it should be completed) trigger if the status in In-Progress.

If you have any other queries revert back or the solution is not feasible for your requirement. Kindly elaborate the problem so that any one from community can also assist on top of it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No