Condition based on a List Item equals Forms answer

(0) Share

Report

Posted on by Drangua

Hello Cummunity,

I got stuck on this, no matter what I try it wont work.

If list Item RQMS equals forms RQMS then update the rest of list items, if not don't do anything. Both are number fields... and it wont work. Any Idee on what am I doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Drangua please cloud you add a complete screanshot? If I understhand well you need to compare a result of forms to item in sharepoint so please try

Was this reply helpful? Yes No
Drangua 29 on at

Like (0)

Report
Copy link

Link copied!

hi @ChristianAbata I tried that also, butt I get same results. Yes I'm trying to compare forms results with sharepoint item and update only if it's a match.

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Drangua please try adding trim('YourValueFORMS') and compare with trim('YourValueSHAREPOINT')

Was this reply helpful? Yes No
Drangua 29 on at

Like (0)

Report
Copy link

Link copied!

@ChristianAbata nope didn't help... I'm getting an error

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Drangua the error says that you need a string value please try trim(String('YourValues'))

Was this reply helpful? Yes No
Drangua 29 on at

Like (0)

Report
Copy link

Link copied!

@ChristianAbata returns false 🤕

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If returns false, please use contains.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Drangua ,

Could you please take a try to help me to troubleshooting your flow by add 2 Compose in your flow before the Condition?

The screenshot of the flow as below:

You need to save the value from the sharepoint column and response question in the two Compose action, and you could compare the compose in the condition. if your the condition run with false result, you could check the value in the Compose and Compose 2 to see the values in it in the flow run history, and you would know the reason of why the Condition don't work.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No