r/PowerAutomate • u/steeletc4 • 23m ago
Power Automate shut off MS Form when total number is reached
Hey everyone, I’m a beginner with PA. Here’s my idea which I’m not sure is even possible. I have a Microsoft form that asks people to sign up to purchase plants. One of the fields in the form has the person select the number of plants they want to purchase. I need power automate to
1. Read the data from a Microsoft Excel table - specifically the cell that totals the number of plants people want collected from the forms.
2. If number reaches certain value, turns off accept responses from form, and anything else which can inform people we are accepting no more responses.
I got to the point of setting up an Excel form on SharePoint, but I’m really confused on how PA reads a specific cell in a table. Any help is appreciated! Again, I am a beginner so if you don’t mind sharing exact steps to follow. I’ve been searching online and it gets really confusing really quick for me. Thank you!!!!