Unanswered

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:

Business Process Flows

All responses (3)

Answers (0)

Suggested answer

MS.Ragavendar 1,087 on at

Like (0)

Report
Create a flow

@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
ronaldwalcott 1,988 on at

Like (0)

Report

Create a flow

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
Michael E. Gernaey 38,415 Super User 2025 Season 1 on at

Like (0)

Report

Create a flow

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. :-)

Community site session details

Create a flow

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Create a flow

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates