Send Email base on a Due Date coulmn in sharePoint? Help

[David1966]

Hi Ive been at this for hours and can,t get it to work i just sent myself 2400 emails in one hit here what im trying to do.

• Ive made a power app that keep track of item within the First aid kit so you don't have to take every item out to check the use-by dates.
• You can update a SharePoint list within the app if a new item is added.
• Im now try to make a flow that checks the SharePoint item to see if any are close to "14 days" or out of date and send a email.
• Ive been at it for the last 6 hours and just sent myself 2400 emails.
• before it just send a email for every item that was out of date.
• So is there anyone that can help me you have to Dumb it down as im new to this.
• i have done this with excel many years a go.

A guide or video would help but i think Ive watch 30 or more today im off to bed so if i don't respond straight away do worry.

THANKs

[v-mengmli-msft]

Hi @David1966 ,

Do you want to filter items out of date and send an email to each of them?

Could you please provide more details?

1/What are the types of your columns?

2/Where do you get the send email address? Column in SP list?

3/Does the difference between the created date and current date be 14 days?

I believe more details will be helpful for community members to understand what you need.

Best regards,

Rimmon

[abm]

Hi @David1966 

Try the below:

The expression I used under compose 2 is:

formatDateTime(addDays(utcNow(),14),'yyyy-MM-dd')

Above ExpriyDate is a DateTime field column

Thanks

[David1966]

Getting this error

{
  "status": 400,
  "message": "The expression \"Due Date le '2024-04-15'\" is not valid. Creating query failed.\r\nclientRequestId: 2f9c68cf-425d-4da6-9fe6-8e45a592c22e\r\nserviceRequestId: 2f9c68cf-425d-4da6-9fe6-8e45a592c22e"
}

Date column

Column

Status is 

Days Remaining

error im now getting in app

[abm]

Hi @David1966 

Here look the browser url it should show you the actual column name you can use under the filter query. Either it should be DueDate or Due_x0020_Date. Check the browser url end it says column=xxxxx

[David1966]

Whats next create a HTML table? been sitting here for the last hour deleting 2000+ emails from ipad so dont want to do that again.

[David1966]

Were do i go from here ive try diff things but i ever get a error or 3 email with diff items or 3 items with the same name in one email Help please?

[abm · Accepted solution]

Hi @David1966 

Remove the Apply to Each action step. Add Create Table Action step. See below.

This will create the HTML table with all the fields.

If you want certain fields then do the custom one. See below I want Title and Description. Expression I used below are:

item()?['Title]

item()?['Description']

Finally you can map this output to your email.

Thanks