Each month 10% of all clients applications for funds will be randomly picked for inspektion. I have solved this by craping data from our buinessapp and done a radom pick where the clients personal numbers are added to the H colum in a excel spead sheet. Now I need to match each cell with reponsable personal by using the variable from each cell and type into the buiness app for a lookup to send them a message to contact their client.
I need some help. So the senario is that I have some data in colum H in excel where I need to assign a variable for each cell. This variable will be used later in the flow to be entered into our business app.
The problem is that I dont know how many cells in H has value as it changes every month (10%, but maximum 20).
The number of times I need to preform the lookup action in the application depends on how many cells there is (one cell = one action). So I somehow first need to get a variable for each cell that has a value in colum H and then tell UiPath how many varibles (cells) where created and run the actions in the business application equal amount of times.
I am really lost in this and would really like some help. Working withh excel and uipath is new to me. Thanks in advance.