Answered

Push notification to predefined list

(0) Share

Report

Posted on by Owizardo

Hello,

Would anyone know how to send a push notification to a predefined email list? For example I have a SharePoint list with 2 columns, a user name and an email column.

Doing something like this just dosent work:

ClearCollect(Push_List, SharepointPoint_List_With_emails);
PowerAppsNotification.SendPushNotification(
{
 recipients: SharepointPoint_List_With_emails.Email ,
 message:"Test",
 openApp:true
})

Would anyone know how to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report
Use the Concat() function to create a string of semi-colon separated email addresses, then use that as the recipient email address in a flow.

So, using your example you might do something like this. Create a Flow with PowerApps as the trigger, then the next step is Send an Email (let's call the Flow called SendEmail). In the Send and Email action, set the dynamic content of the To address to be "Ask in PowerApps" then add it to PowerApps and run it with:
SendEmail.Run(Concat(SharepointPoint_List_With_Emails, Email & Char(59)))
The fact the string of email addresses is semi-colon separated *should* be acceptable to the connector, although I haven't tested it. You might need a space character after the Char(59), e.g
Concat(SharepointPoint_List_With_Emails, Email & "; ")
You can use the Char() function or a double-quote encapsulated string in the Concat() function, it doesn't matter in most cases.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @Owizardo
Do you want to send Push notification to the Email addresses recorded in a SharePoint list?
The correct syntax is：
PowerAppsNotification.SendPushNotification({recipients:[“ID1”,”ID2”,…],message: "…"})
or PowerAppsNotification.SendPushNotification({recipients:[“email1”,”email2”,…],message: "…"})
The data type used after recipients should be string array.
You could try this formula:
PowerAppsNotification.SendPushNotification(
{recipients:ForAll(SharepointPoint_List_With_emails,Email),
message:"Test",openApp:true})
The function of ForAll can convert columns to values.
Here's doc for your reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-forall
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-notifications#send-a-notification-from-an-app

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Eraser 8 on at

Like (0)

Report
Here is the solution I used to accomplish this. Keep in mind this is not a very efficient way to accomplish this, but it works. I only tested this using a few email addresses, and there was no noticeable delay, your mileage may vary based on the size of your table.

senderList is a single column table with the email addresses to send the notifications to.
ForAll(senderList, PowerAppsNotification.SendPushNotification({ recipients:[emailAddress], message:msgTxt, openApp:true}) ));

If only the context menu for this function was actually correct, this process would be pretty trivial. Being able to pass a Table to the recipients parameter would make life so much easier.

The PowerAppsNotification function requires a String array for the recipients parameter. Here is why the prior examples won't work:

Using ForAll function to return the values for the recipients parameter will not work as that function returns a Table and not a String array.
You can't create a String array using the Concat function as the results will end up being a string. You can simulate the results by simply using a string like this "emailAddr1@mail.com;emailAddr2@mail.com" as the value for the recipients parameter. The string will be accepted, however you'll get a runtime error that the email address is invalid. As far as I can tell there is no way to programmatically create a String array within Power Apps. Functions I thought would work such as Split, return a table, which can't be used.
Hopefully proves useful to someone.

Was this reply helpful? Yes No
halohu2023 3 on at

Like (0)

Report

Thank kiu! You just saved my day!

Was this reply helpful? Yes No