Dynamic Timezone selection based on Country, State and City

Hi Team,

My task is to select the timezone from a dropdown list. Input will be Country, State and City. Providing the country, state and city my automation should dynamically select the timezone. Please provide ideas

Hi @poornima.sadasivan
Welcome to UiPath,

Maintain a mapping of Country, State, and City to timezone in a dictionary or Excel, look up the timezone based on input, and use Select Item or Type Into to choose it from the dropdown.

If helpful, mark as solution. Happy automation with UiPath

hi @prashant1603765

Thankyou for your response. But that is the challenge here. The country, state and city are free text fields and there could be typo errors or for example: Australia will be written by vendors like AU/AUS/AUSTRALIA..so the combination is random. We receive requests, only when there is a new combination of country/state/city is entered. Hence storing the timezone and retrieval will not be asuitable solution here. The timezone has to be derived dynamically.

Hi @poornima.sadasivan

Welcome to UiPath!

Store a Country–State–City to Timezone mapping (dictionary or Excel), retrieve the matching timezone, and select it using Select Item or Type Into.

If this resolves your issue, kindly mark it as the solution. Happy automation!