Unanswered

I am trying to set up a recurring email with specific items from a SharePoint list

(0) Share

Report

Posted on by DLynch

Help please:

I am trying to set up a flow that sends a recurring email daily from a SharePoint list. The list contains daily requests. I want to be able to send specific items based on the value in one of the columns so my team can see what requests were approved for today. I want the flow to only send the items that have a date that matches the day the recurring email will be sent.

I have set up a flow a few different ways but continue to run into the same problem. The flow will generate multiple emails(one for each line item/row) instead of listing them all in one email.

I have tried:

1.) recurring:

get items : SharePoint list

apply to each: value

condition:(if column is equal to current date): send email: desired columns using dynamic expressions

2.) recurring:

initialize variable: (string)

get items: SharePoint list

apply to each: value

append string variable: (list/ each column desired)

condition: (date column must equal today)

send email: (variable list)

3.)I have also tried using an html table but this seemed to generate the whole list or fill every row of the table with the same line.

Any assistance would be appreciated.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

janessanelson 34 on at

Like (0)

Report

1. You want to create a variable at the start that is a string. Use the initialize variable action.
2. Use a condition prompt to specify which variable you want to filter out. If they match your condition variable(s), (you can do one or multiple conditions), then it will write into the string variable using the append to string variable action.

The string variable can handle html formatting - so you can add various html formats to make it look like a table.

3) Then you can add your email action after the "apply to each step" and insert the string variable as a dynamic component within the email.

Was this reply helpful? Yes No
DLynch 6 on at

Like (0)

Report

Thank you for the response.

I am yielding the same result by using the above mentioned solution.

For example:
My list has 3 entries that match the criteria.
I am receiving three separate emails with one line each instead of one email with all three entries.

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (0)

Report

Hi @DLynch ,
I made a template for your reference:
Here is list

Here is flow:
Filter out the column whose date is today through filter query
Make it into Html Table

Here is result:
Here is a link about filter query:
Power Automate OData filter query with examples - SPGuides

Best Regards
Cheng Feng

Was this reply helpful? Yes No
DLynch 6 on at

Like (0)

Report

Thank you!

This solution worked.

Was this reply helpful? Yes No