Hi All,
I’ve a use case wherein I’ve to loop through the excel sheet names and add those name to a List variable based on a check done with a predefined list.
Predefined List : New List(of String)(New String(){“COO”,“BSS”,“INTER BRANCH”,“LOCAL BRANCH TEST”,“AGENT COMMISSION”,“AGENT COMMISSION-HEALTH”})
Problem statement : I’m able to add the sheet name based on predefined list. Only for the agent commission-health value it is giving problem not able to add to the list variable. Tried split approach it is not working.
Have attached my excel input and xaml file for reference.
Any kind of assistance would be of great help. Thank you in advance.SampleData.xlsx (10.3 KB)
Main.xaml (14.3 KB)