Answered

Creating Recurrence flow to send items created on SharePoint List (for every user)

(0) Share

Report

Posted on by MSDigitalUser

138

I want to create an automated flow to send email on weekly basis with items on a SharePoint list, but I need to send the items for each user CreatedBy. -> and I need to avoid duplication of emails

1. Recurrence

2. Get items

3. Apply to Each

4. Filter Array
5. Create HTML Table
6. Send email

the flow is not working properly, and I want to send only 1 email with all the items created by each user.

Thanks,

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MSDigitalUser

Does the flow should only capture items created within that week ? or it should send all items details to respective user who created it ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

Hello Nived,

It should capture all the items created to the respective user.

Thanks,

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MSDigitalUser

Try this approach

1. Use get items to get all list items

2. Use select action to select Created By Email dynamic content and store as array format

3. use apply to each to loop through distinct list of Created By Email array

Inside the loop, do the following:-

3.1 - Filter the value dynamic content based on Created By Email equal to current iterating Created By email in apply to each loop like below

3.2- Create html table out of output from filter array using specifc columns

3.3- send an email to the created by person using send email action

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

I got the above errors

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MSDigitalUser

There is no need of using apply to each after filter array. see my response

I have just used the output of filter array to create html table action

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

still the same error

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MSDigitalUser

could you show me what parameters you have passed to the Create HTML Table ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

Also, when I make a custom HTML table, it adds for me " for each "

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

it worked well , thanks a lot for your support ! 🙂

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

May i know how the error got resolved ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No