Convert string in excel field into a dictionary

Excel field contains multiple skills and level the person has a skill separated by a new line.

e.g. Skills: ’ French L2, German L1, Spanish L5’

I need to access the skill name and the level of each skill. Is there a way to convert the string in the skills field into a dictionary?

e.g. mydict = {French: L2, German: L1, Spanish: L5}

How do I later access the element of the dictionary in UiPAth?

Hi @Aishwarya_Maggi,

Hope this could help you:

You need to install Microsoft.Activities.Extension for using the dictionary activities:

Best Regards,

1 Like