How to fetch Unique values from a List Variable

Hi All,

Need your help again.

I have one excel file, please refer below screenshot.
image

Column E has App codes and each app code has some email ids assigned to them.

I am using foreach loop on Column E to send emails.

But since Column E has same app codes more than 2 times say PSG_DBSSAPP_CRDD , because of this the BOT is sending email 2 times.

All I want Is bot to fetch unique values from Column E and send email accordingly.

Any suggestion will be appreciated.

PS Note no Unique function is available in current version of MS Excel.

Hi @karan_singh2a,
Here’s one solution to get the unique list from the original list.
The method is using For Each + IF NOT CONTAINS + Expression value + Join Strings
Reference bot: Get Unique List.zip (1.4 KB)
Original Data:
image
Variables:
image
Actions Flow:
image
Result:

2 Likes