Insert value in a SPO column based on value in another

(0) Share

Report

Posted on by MM-05080756-0

410

I thought this would be an easy one, but no ...

I am building a Flow for one use only in a Sharepoint list: I manually trigger the Flow, get the items from Sharepoint list, then I want the items that have the value 0 in Alternatives column "Besvarad" to be updated with the value No in Yes/No column "Besvarat".

The Flow runs seccessfully, but nothing happens in the list. What is wrong?

Alternative 1, with condition:

I have tried to use both "Besvarad value" and "Besvarad" in the condition, and tried with both "is equal to" and "is less or equal to".

Namnlöst-1.png

Alternative 2, with Filter query:

Namnlöst-2.png

All responses (4)

Answers (1)

MM-05080756-0 410 on at

Like (1)

Report

Re: Insert value in a SPO column based on value in another

You're completely right - the value was blank. I thought about it once again and changed the Filter query to
Besvarad eq '0'
and that made it work. Guess I should have thought of that myself 🙂
Thanks!
Verified answer

abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Insert value in a SPO column based on value in another

Hi @MrtnM

Check your run history results. Most likely the value is blank. In that case better to use an expression to check empty or length to determine whether a value exists or not.

Please let me know how it goes.

Thanks
MM-05080756-0 410 on at

Like (0)

Report

Re: Insert value in a SPO column based on value in another

It's an Alternatives (Options?) multiple choice column.
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: Insert value in a SPO column based on value in another

Hi @MrtnM

What is your data type for 'Besvarad' column?

Thanks