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
Super User
Super User

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,018)