Checking manual entry and auto calculation

[HK001]

Hi,

I designed a form to collect information from users with Microsoft form. Users need to do a calculation to answer a question.  What I want to do is if the information entered in the form is actually correct I want my workflow to start. F.e. 

Question 7 > Please insert ABC data

Question 8 > Please insert BCD data

Question 9 > Please insert ABC/BCD ( Question 7/Question 😎 value.

My solution is,

1. I have created excel file in OneDrive and when I get new answer from foms then insert to this answer.

2. I added a column for automatic calculation "=EXACT(K2,L2)"

3. I have created flow for this process

But I can't pass condition. What can I do for pass this step?

[mahoneypat]

Do you need to do the check in Excel?  Why not just divide the #s in your flow and check it against the Q9 value in your condition step?

Pat

[v-LilyW-msft]

Hi @HK001 

Could you further explain what conditions are met and flow to start?

When the value of Question9 is equal to the value of Question7 plus the value of Question8, run flow? Otherwise do nothing?

Best Regards.

[HK001 · Accepted solution]

Hi,

I have solved my problem with two steps.  You can find details.

Best Regards

concat(outputs('Get_a_row')?['body/AutoControl'])

contains(variables('AutoControlText_v2'),'true')