How to create dictionary variables - Microsoft Power Automate Tutorial

If you're creating a bot involving values that may change at some point in time, you might want to consider using a dictionary variable type.

Instead of hardcoding the values in the script, you can store this information into an Excel file and just specify the "key" of the dictionary variable in your script. This way, the process is more robust and users can change the information anytime.

In this video, we'll go through how you can create a dictionary variable in Microsoft Power Automate for Desktop.

00:00 Introduction
00:55 Set custom object variable to create the dictionary variable
01:36 Create subflow to read from Excel file and assign key and value to the dictionary variable
08:40 Retrieving a value from the dictionary variable

Related videos:

Keep in touch!

#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate

[rpaupbeat]

definitely gone a make video for this. very helpful.

[kashifkhanspecial]

Hi,
Thank you so much for this great tutorial, I have some request/questions regarding LIST/DICTIONARY.

1). List/Dictionary: How can we check existence of an item in a List/Dictionary, before adding in List/Dictionary?

Example: there is a list/dictionary variable "vardic" and item added in this variable are "a", "b" and "c", and I want to add item "c" but before that I want to check that if the item is already added in the list/dictionary or not if not then only will add the item.

2). List/Dictionary: How can we add multiple column custom object in a List/Dictionary?, for example multiple columns like empID, EmpName, EmpAge, EmpSalary etc

Example:

EmpId EmpName EmpAge EmpSalary
1 A 20 50000
2 B 15 60000
3 B 40 50000

3). List/Dictionary: How can we fetch multiple columns value against a key, for example I want to fetch all the columns value (EmpName, EmpAge & EmpSalary) against an EmpId?

EmpId EmpName EmpAge EmpSalary
1 A 20 50000
2 B 15 60000
3 B 40 50000

If I will paas EmpId (1) then the only 1 rows will fetch for the columns (EmpName, EmpAge & EmpSalary).

4). List/Dictionary: If an Key columns "EmpId" is duplicate then I want to fetch all the columns (EmpName, EmpAge & EmpSalary) value against that key?

EmpId EmpName EmpAge EmpSalary
1 A 20 50000
2 B 15 60000
1 B 40 50000

If I will paas EmpId (1) then the 2 rows will fetch for the columns (EmpName, EmpAge & EmpSalary).

How can we perform these kind of tasks in Power Automate Desktop.


Thanks in advance for all of your help.

Thanks
Kashif