This should probably be in the Power Automate forums, but since the end result is a push notification to a Power App, here is a system that works well for me:
One method is to set a recurring flow that looks to a SharePoint list for a starting date and if that date is less than Now() process the list item into a push notification. The flow below looks to a notification list to process the push message text and recipients, then looks to another user list to match the notification recipients' project, role, and discipline to construct an array of users.
To get the initial notification, I use the filter query to determine if the time is ready to send the push. My query is a bit more complex as there is also an end date and other flags that need to be checked:
notifScheduledBOOL ne false and notifCompleteBOOL eq false and notifSendDateTime lt '@{convertFromUtc(utcNow(),'Central Standard Time')}' and notifExpirationDateTime gt '@{convertFromUtc(utcNow(),'Central Standard Time')}'
The above just gets the notification to push out, as well as the recipients' project, role, and discipline. These values are in a user list, so we need to query that list to get our emails and append to an array. Unlike sending an email to multiple recipients, where you construct a semicolon separated string, the Push Notification action wants an array. To create the array, loop through your emails and append to array. If you need to make a dynamic filter query, here is an example of that. Otherwise, you may be safe to hard code or skip the filter query:
To build the array of emails, apply to each user found - append to array var. Then you are ready to send the push notification:
