How to get the reference data from an excel sheet?

I want to get the capital city (Column2) as an output by using the country name (Column1) from an excel file.


You type the country as an input and the workflow outputs the capital city.


Output is a capital city

get your data into a data row and using for each row activity you can check the country using assign activity and get the city from that data row

1 Like

Thank you so much @Vidwa
It is now working (21.4 KB)

Main.xaml (9.6 KB)


You can try with this (21.4 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.