cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HK001
New Member

Checking manual entry and auto calculation

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)"

22.png

 

3. I have created flow for this process

23.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
HK001
New Member

Hi,

 

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

 

Best Regards

 

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

HK001_0-1637243140441.png

 

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

HK001_1-1637243208172.png

 

 

View solution in original post

3 REPLIES 3
mahoneypat
Dual Super User
Dual Super User

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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
New Member

Hi,

 

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

 

Best Regards

 

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

HK001_0-1637243140441.png

 

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

HK001_1-1637243208172.png

 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,076)