How to use flow switch activity

[T_Y_Raju]

i have excel workbook which has different sheets…how can i flow switch activty here

for example workbook has sheets like, ,WLC, Was, router, AP, interface like that

firstly iam geeting all the sheet names so once sheet name is WLC…bot should go to WLC sheet and do the further steps, if sheet name is router… bot should go to router sheet

[Sudharsan_Ka]

HI @T_Y_Raju

It is same like switch activity , checkout this video

UiPath Flow Switch Activity|UiPath RPA Tutorial

Regards
Sudharsan

[lrtetala (Lakshman Reddy)]

Hi @T_Y_Raju

->Store the Sheet names in an array then use for each loop in that use switch cases

[T_Y_Raju]

i have gone through this not much useful…can u build any workflow on the above eaxmple

[Sudharsan_Ka]

Find the screenshot @T_Y_Raju

Regards
Sudharsan

[T_Y_Raju]

here i have to read excel work book and when particulcar sheet name comes it has to go to the flow switch part…here i cannot take flow switch activtity side the loop.

[Sudharsan_Ka]

Flow switch will be placed only inside flowchart

Do you have Flowchart inside for each @T_Y_Raju ?

Can you send your workflow screenshot?

Regards
Sudharsan

[T_Y_Raju]

iam using flow chart

[Sudharsan_Ka]

Okay but what’s the problem you face here @T_Y_Raju ?

Can you elaborate please?

You want to loop through all the sheets one by one?

Regards
Sudharsan

[Sudharsan_Ka]

@T_Y_Raju

If you want to loop through all your sheets you can try like this

After excel file processing use For each and in the list give the List variable you got from get workbook sheets activity

Regards
Sudharsan

[T_Y_Raju]

i got it thank you very much it worked

[Sudharsan_Ka]

That’s great @T_Y_Raju , Kindly mark the appropriate post as solution so that it can be helpful for others

Regards
Sudharsan