Insert value in a SPO column based on value in another

(0) Share

Report

Posted on by MM-05080756-0

442

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)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MrtnM

What is your data type for 'Besvarad' column?

Thanks

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

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,998 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 442 on at

Like
a
(1)

Report
Copy link

Link copied!

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