Answered

Send emails to user by unique values based on when item is modified

(0) Share

Report

Posted on by Simsingh

Hello i am trying to send unique emails to multiple users with specific data when item has been modified on sharepoint will be the trigger

Following is my sample data

i am able to get emails by unique values

after following the following guide

https://m.youtube.com/watch?v=BBB-4GzH5KE

however issue i am running into is along with emails i would like to retrieve the values for the users to include in body

example

send email to test@test.com

body FruitType Apple, Orange

i tried multiple ways to combine the values however it's just returning one raw data of first item

as far as changes goes i am pulling by since versionID

with my current setup i am able to notify user however it's sending multiple emails to same user except for multiple emails i would like to combine into one email that has new unique values

any help will be appreciated

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Simsingh Once you got unique email use Apply to each action and pass compose 2 output in input value. Then inside loop use get items with filter query. use filter query with your email so that it will give you all unique email row items. Then use create html table action which you can use in send email action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 thanks for helping out again :0

so when i try to get items results are returning null

this is what i am using for compose

union(variables('UniqueUsersEmails'),variables('UniqueUsersEmails'))

Was this reply helpful? Yes No
Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 when input the value manually of the email the results are what they are suppose to be and the table does get created

Was this reply helpful? Yes No
Verified answer

Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 i found the issue the issue related to text not being simple text when using compose through union i had to use replace for quotes [] is there simple way to do it had to use compose 4 times to replace the string

Was this reply helpful? Yes No
Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

thank you for your help
replace(replace(replace(string(outputs('Compose_2')),'"', ''),']', ''),'[', '')

Was this reply helpful? Yes No
Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 just noticed an issue when using get items since it's same data i am looping from where there are multiple records for same users so when notifications are being sent out each user will have anywhere from 5-10 records i am getting multiple notifications. My condition is based on column status any help will be appreciated

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Simsingh It means that you are looping send email action . Make sure that send email should be outside the loop.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
Simsingh 95 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 this is the way i have it after condition of has column name updated is equals true then i have other conditions that follows please advise thanks

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Simsingh Pls Share your complete flow. Message me.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No