I have a CSVTable as belo:
I want to send email to each "UserID" with the "Number" in the Body email.
Subject: Take action
Body: Hello Rickard, Please check XXX0000066 and XXX0000068 as soon as possible.
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.
Please refer following ...
split(item(), ',') split(item(), ',') split(item(), ',')
@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