I am trying to build a flow where I can let the user decide how many rows that need to be added in a excel table based on their input in forms.
For example, the user says "9" rows are needed in the form. Then this amount of rows are added in the excel table.
Can you help me?
Hello @Alexpett ,
If you want to create a specific number of rows based on customer's input, you can try to check if with the Do Until control you are able to.
The logic i followed is that you have the number of rows you want in a variable and decrement it after a row is created and allow the next one to be created as well.
On below flow test, i am initializing a variable with a fixed value, on your case, it will be the customer's input and then i addded a condition so that the excel action can stop.
On your scenario, you may need to place other verifications such as limit the number the users can place in the form otherwise the actions the flow will consume could hit the Flow Limits.
Please have a look and if you think it was useful, let me know.
Tiago Ribeiro | Power Platform Support Engineer
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.