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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,472)