Hi,
The Result column should be automatically populated with the value from the Type column. The Type column has a choice view. This works well if you use calculated in the Result column.
However, I may have the option to select multiple values at once in the Type column, so I use checkboxes (allow multiple selections). In this case, calculated no longer works in the Result column.
I tried to set up a flow in power automate, but failed.
Please tell me what am I doing wrong and how can I fix it. Perhaps there are other options.
My PA flow: Then I add the document to the library. Set the Type ID1 and DEV from checkboxes for it.
After flow was finished I get the following changes.
The debugger shows that the flow was finished successfully, but it showed the true for the first condition, although there was a condition for DEV, not for my ID1;DEV.
Yep! Plus I think that I gave you a solution, here, @Pavel48n0sh.
Oh, sorry. I forgot to add screenshots of my flow.
Already fixed 🙂
Alternatively, @Pavel48n0sh, you could try this hack from stack exchange (which I'm putting in my bookmarks for later! )
You will need to ensure that your calculated columns calculations are all finalised before step 4.
This requires zero Power Automate use, and means that you also avoid having to deal with loop avoidance. 😉
Show us what you've tried so far, @Pavel48n0sh.
I might not be able to help, as I'm a bit looped out ... but if you place pictures of your failed flow in your question it can really assist people here in helping you.
Just blank out (obfuscate) any private data.
Also, watch out for running a flow on a SharePoint list triggered by modifications if you want to modify the list ... things get complicated fast because you could make loops.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1