Insert value in a SPO column based on value in another

(0) Share

Report

Posted on by MM-05080756-0

431

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @MrtnM

What is your data type for 'Besvarad' column?

Thanks

Was this reply helpful? Yes No
MM-05080756-0 431 on at

Like (0)

Report

It's an Alternatives (Options?) multiple choice column.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
MM-05080756-0 431 on at

Like (1)

Report

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!

Was this reply helpful? Yes No