Hi,
My aim is to input data from an excel spreadsheet into an eForm.
Problem is, a part of the eForm contains a drop down list which induces more rows when selected.
I’m using the Switch command to allow Ui Path to differentiate between the different rows in the eForm.
My issue is that my current workflow can’t differentiate which choice I have made in the eForm.
Please advise
Hi @Izzat_Nasser
Welcome to community
Can u elaborate your case more
Is the drop-down list elements is different in format that of excel
Hi @NIVED_NAMBIAR,
Thanks for reaching out!
I have multiple sequences that can only be induced depending on the situation.
Can I use this workflow?
Start >>> Excel Application Scope >>> Flow Switch >>>> Sequence (That contains “Type Into” command)
Is this possible?
Like u mean values in drop-down are different type like that of values in excel
Correct.
So say for example
I have an excel sheet, that contains columns A B C D E F and rows Individual 1 and Individual 2.
AND
I have a Form that needs to be populated by the data in the excel sheet. In this form, I have two selections, Selection 1 and Selection 2.
Note that :
Individual 1 will choose Selection 1
Individual 2 chooses Selection 2
So my main question is
Say for example
Situation 1:
In the form, I choose Selection 1, and I only want the columns A B C to be populated into the form.
Situation 2:
In the form, I choose Selection 2, and I ONLY want columns D E F to be populated in the form.
Can I use Flow Switch to redirect the Sequences.
Since there are two Selections, thus there are 2 Sequences.
And in each Sequence, I have “Type Into” commands which populates the respective data into the Form based on the columns in the excel sheet.
Please advise
Yes u can do like that
On what basis u are making selection , automatically or manually?
Since Individual 1 is making Selection 1 and Individual 2 is making Selection 2,
Then the selections are done automatically since this will be predefined in the excel sheet
@Izzat_Nasser
U can do this by using ur above sequence, but make it inside for each row
How do I define the case when I am using the Flowswitch?
Hi @Izzat_Nasser, since when. Individual changes, we have to make everything different
So u can put case value is individual name
Since based on individual we are inputting data