Answered

Creating a Flow to Update all List Items

(0) Share

Report

Posted on by nathanisaacson

I'm trying to create a flow that will update a column on ALL items in a list, based on responses in another column. Please see the attached screenshots for reference: the flow should put a 'Yes' in the Security column if 'Security' is one of the selected choices in the Domains column. I'm having trouble figuring this out. I've built a flow (screenshots attached) but when tested, it puts a 'Yes' in the Security column of all items regardless of whether or not 'Security' is one of the selected choices in the Domains column. FYI, the output I've placed in the 'Apply to Each' is 'value - List of Items'. Many thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You are appending string to variable, so it append first item data which contains "Security". On next loop, you add second item data, but first one's data still present and your condition remains true.. Use "Set variable":
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

@nathanisaacson Hi can you tell me what type of columns are the Security, Governance, etc? I'm assuming they are text type and they are not boolean type?

Was this reply helpful? Yes No
nathanisaacson on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response! I'm following but still a little confused on the solution. Any chance you could build it out for me so I can replicate it on my end and see if it works? Apologies, I don't often work with variables.

Was this reply helpful? Yes No
nathanisaacson on at

Like (0)

Report
Copy link

Link copied!

The Security, Governance, etc. columns are Yes/No.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

I proposed to replace your "Append to string variable" by a "Set variable". Variable will only contain current item domains on each loop.
Actually each loop appends current item domains to variable which kept previous items ones. On second loop, it updates "Test2" item, because variable still contains "Test" domains where there is "Security" which makes the condition returning true.
You could also use "Domains" dynamic content directly in the condition, variable looks useless.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Verified answer

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I suggested replacing your "Add to String Variable" with a "Set Variable". So the variable will only contain the current item domains on each loop.
In fact, each loop adds the domains of current item to the variable which kept those of the previous ones. During the second loop, it updates the "Test2" item, because the variable still contains "Test" domains where there is "Security", which makes the condition true.
You can also use the "Domains" dynamic content directly in the condition, the variable seems unnecessary.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you look at this post and see if it helps. (User didn't mark my answer as solution grrr..) But if you scroll down I have a lot of screenshots that show something very similar.

https://powerusers.microsoft.com/t5/Building-Flows/Update-Y-N-Column-based-on-multiple-choice-field/m-p/2233608

Was this reply helpful? Yes No