cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SiL3nT
New Member

Read from CSV file unique column

Hello,

I have a CSVTable as belo:
Number,Assigned,UserID

XXX0000066,Rickard,Rickard@microsoft.com

XXX0000055,Niklas,niklas@microsoft.com

XXX0000045,Niklas,niklas@microsoft.com

XXX0000068,Rickard,Rickard@microsoft.com

 

I want to send email to each "UserID" with the "Number" in the Body email.

Example:


Mailto: Rickard@microsoft.com
Subject: Take action

Body: Hello Rickard, Please check XXX0000066 and XXX0000068 as soon as possible.

 

Next email:
Mailto: niklas@microsoft.com
Subject action

Body: Hello Niklas, Please check XXX0000055 and XXX0000045 as soon as possible.

 

 

I have tried in few days now but not really understanding it how to. Sorry.

Appreciate any answer.

2 REPLIES 2
PrasadAthalye
Community Champion
Community Champion

Please refer following ...

 

  • Declare a enter character seperator variable and press enter in the value.
  • Use Compose on your data and split the data with seperator variable. This will create an array for each line.
  • Loop through array and use expression like below to read individual value... 2nd index will be email address

PrasadAthalye_1-1628693206087.png

split(item(), ',')[0]
split(item(), ',')[1]
split(item(), ',')[2]

PrasadAthalye_0-1628693129237.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye i want to collect in one email all the Numbers that have as UserID the email for example Rickard@microsoft.com. I know how to do it for each item send email to UserID but instead of 2 emails i want to send the both Numbers in one email. But i don't know how to collect in one value both Numbers that belongs to the UserID Rickard@microsoft.com

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,474)