web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Help required - Creati...

Power Automate

Unanswered

Help required - Creating a scheduled flow from a Sharepoint List

(0) Share

Report

Report

Posted on by kdoh

5

Hello, I am trying to create a scheduled fortnightly flow that sends an email when numerous items in a SharePoint list reach or exceed a "chaser date".

I have created the flow below, although this is not working properly as it is sending multiple emails for each individual item, when what I require is the filtered items to be grouped into one email.

Can someone please take a look and provide an example of a potential solution?

Any help is greatly appreciated.

Best regards

Kelly

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @kdoh

here a quick I tried

In filter array try below correct column name if needed

goto advance mode @greater(formatDateTime(item()?['Outcome_Chaser_Date'], 'MM-dd-yyyy'), formatDateTime(utcNow(), 'MM-dd-yyyy'))

In Create HTML table
pass Body of the HTML table and map columns as below

Title = item()?['Title']

later once you're able to see the table outcome in creates HTML table which can be same used to send e-mail.

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No

Join the conversation