Unanswered

Ms form input vs SharePoint list

(0) Share

Report

Posted on by poh83

hello everyone,

i'm currently working on a flow for checking the user input against my sharepoint list, if the input that user enter is match with the data in my sharepoint list, the flow works well, however when the user input in the Ms form is not match with the record in my sharepoint list the flow will stop at the for Each1 and it will not go to condition, is that any one can guide me how can i fix this ?

attached my flow for your reference, thanks.

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @poh83 ,

There are two things I want to know.

1.What are you using in "Apply to each"?

2.Could you please show some screenshots about the failed flow?

If the Condition checks if answer to one question equals to one column value, there should be just one Apply to each in your flow. Maybe the issue caused by two "Apply to each".

Answer1 equals to first column value, send "True" email.

Answer1 equals to second column value, send "False" email.

If above is what you want, I recommend you modify your flow as below and test again.

Best regards,

Rimmon

Was this reply helpful? Yes No
poh83 16 on at

Like (1)

Report
Copy link

Link copied!

Thanks for replying, fyi the apply each us automatically pop ups.
i have manged to fixed the flow by using the legth() in the condition, now the flow has works as what i need.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @poh83 ,

Glad to hear that the problem has been solved.

You can accept any useful answers to this question as a solution to end the problem.😀

Best regards,

Rimmon

Was this reply helpful? Yes No
poh83 16 on at

Like (0)

Report
Copy link

Link copied!

i have another issue now, not sure whether you can help ?
the first part i have done which is now my flow will check the input against my sharepoint list.

now coming to second part, i'm trying to get the items from another sharepoint list, it seems like now it cannot filter by the query, i had entered the column name which is the same column name in sharepoint however it keep returned error code 400

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @poh83 ,

Try to remove the space of column name in filter query and test again.

Best regards,

Rimmon

Was this reply helpful? Yes No
poh83 16 on at

Like (0)

Report
Copy link

Link copied!

have done that too, still doesn't work.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @poh83 ,

Could you please show the Filter query?

Was this reply helpful? Yes No
poh83 16 on at

Like (0)

Report
Copy link

Link copied!

Sure, I filter Mobile number that user enters against with the second SharePoint list.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @poh83 ,

It's good. What is the Filter query of failed Get items1?

Was this reply helpful? Yes No
poh83 16 on at

Like (0)

Report
Copy link

Link copied!

message": "Column 'Mobile_x0020_Number' does not exist

Was this reply helpful? Yes No