News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Sending email notifica...

Power Automate - Building Flows

Answered

Sending email notification if custom due date is overdue

(0) Share

Report

Report

Posted on by accelle

11

Hello all,

I'm new here as well as I'm new with Power Automate. I have the following issue:

I created a small model-driven Power App, something like a very special CRM
I created an entity for ToDos with a due-date field
Now I want to get daily mails with all overdue ToDos and a link to them, if possible
Unfortunately neither Google search nor Microsoft Support could help me
I created a scheduled flow which runs once a day
I added an Email notification activity
And then I'm lost. I don't know how to access my Power App entity and I also don't know how to run a selection over all the datasets and selecting the overdue ones to create my mail body

Hope there is anyone who can support me.

Thanks in advance!

Best Regards

Peter

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: Sending email notification if custom due date is overdue

Hello @accelle

Welcome to power automate!

All entities in Power Apps are stored in Common Data Service (CDS).

Power automate has connectors for CDS.

Add a List records action. Select your entity name.

Run the Flow, and copy and paste the outputs of the List records action here. So we can better help you with your use case.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans