Condition is not working, it is always false... (Microsoft Forms to SharePoint item)

[ahmadbutt]

- Without the condition the Flow creates a SharePoint item from Microsoft Forms. So this part works good.

- The condition; id-test(Microsoft ID) is the same as Id-test(SharePoint item) does't work, see condition.

Someone got a idea to let it work?

[manuelstgomes]

Hi @ahmadbutt 

The names look the same and from the same source, so I suspect, you're comparing a value with itself :).

If you're fetching the first item from the Form and the second from the trigger body (also the Form) it will always fail since it's the same value.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes Oh.. how do I get the id-test from the SharePoint list item?

[manuelstgomes]

HI @ahmadbutt 

You need to query SharePoint to do that. Just do the following:

The formula in the condition is the following:

length(body('Get_items'))

Basically we're checking if values are returned. If one is returned then the value already exists. If not you can create it.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes The yellow marked is different with yours? I get a error when I run with this...

 

[manuelstgomes]

Hi @ahmadbutt 

It's normal. I needed to use another trigger to get the screenshots because I don't have a form ready, but it should work.

Can you please show me the error?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes this is the error:

[manuelstgomes]

HI @ahmadbutt 

Is the datatype in SharePoint of the "Id-test" a number or a text?

If it's a text you need to include an ' between the value.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes Can you maybe send a screenshot so I can understand it better? It's text. yes.

[manuelstgomes]

HI @ahmadbutt 

Here's the formula:

Id-test eq '@{body('Get_response_details')?['Id-test']}'

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes I get the same error again..?

- I also tried with other id numbers like 17...

1. 

[manuelstgomes]

Hi @ahmadbutt 

Hum.. We'll figure this out don't worry.

Can you share the "Get Items" action including the formula?

Just for me to try to understand what may be wrong.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes 

Formula: Id-test eq '@{body('Get_response_details')?['rdc3f629f323645aab075cc1e49671c26']}', COPY en paste <--,

Same as picture so: Id-test eq 'Id-test'

--

[ahmadbutt]

@manuelstgomes , I just copied the formula in the text field. Do I need to do it with the dynamic content or Expression? This is not possible to do..

[manuelstgomes]

HI@ahmadbutt 

Just copy it directly into the Filter query's text box. It should work it's magic there and you don't need to worry 🙂

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes I did but I get the same error as in message 11... error 400..

[v-litu-msft · Accepted solution]

Hi @ahmadbutt,

The issue may be caused by the column name "Id-test" is not valid, you should encode the "-" character when you use the ODATA filter query, for example:

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

[ahmadbutt]

@v-litu-msft That works now but the condition doesn't. See error:

I also tried with array(0), string(0) and just 0.. 

--

[v-litu-msft]

Hi @ahmadbutt,

Please use the length(body('Get_items')?['value']) on the left side of condition, number 0 on the right side:

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

[ahmadbutt]

@v-litu-msft The False condition works now with creating a item, but the True condition doesn't work. I get this error: