I have excel file attached here for reference[Template.xlsx|attachment]
Template.xlsx (11.2 KB)
This is my main sheet
I have created sequences as per other sheet e.g. prashant.xaml,tushar.xaml.
Form main wrokflow is create as --> if name = “Prashant” ->then ->invoke “Prashant.xaml” elseif …(validate other names)
Inside other sheets e.g Prashant,tushar,etc i am having multiple data.
“prashant.xaml” workflow is --> used for each row ->sheet name(Prashant)-> fill data into form(should fill data by index number) same for other xaml.
main excel having names in random order.
when name =“prashant” for 1st time “prashant.xaml” should take all values for 1st row.
only selected one in above snap.
and if getting name = “prashant” for second or 3rd time “prashant.xaml” should take values for next row.
i am not getting it how to take value from the sheet by index or else
note :- maybe my explanation is little complex