Answered

Loop through web process

(0) Share

Report

Posted on by IsaacR

Hello,

I am new to Power Automate. I was able to create a flow that launches Excel, launches browser, inputs a specific number and searches by that number. Then it extracts data from that profile on to excel. It is working so far but I want it to look the action of changing the number that is input +1 and then running the script again. For example, I want it to type in # "350", go through the process and then do the same for # "351." I found some videos on how to do this with word but not to do this if the input is online.

I also wanted for the flow to ask what you want to set the first instance as and then start the count from there.

Any help would be greatly appreciated.

Categories:

Power Automate Desktop

All responses (3)

Answers (2)

Sort by

Verified answer

fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

For a simple number input this action should do it: https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/display#inputdialog

For more sophisticated things: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Any-estimated-date-for-implementation-of-Custom-Dialog-system/m-p/877932/highlight/true#M2734
IsaacR 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks fraenK, I was able to get my loop to work and was able to create an input dialog but both links do not say how I can set the user input as a variable to set my loop. Right now I have LoopIndex set from 350 to 380 with step 1 but if I try to refence the "from" as the variable "UserInput," it gives me error
Main 3 Parameter 'Start from': Expression must contain a 'Numeric value'.
Verified answer

fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

You'll need to covert the text output of the input dialog to a number first: https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#tonumber
Don't forget exception handling as a user might enter real text which can't be converted into a number.