recipients for push notification using an excel file as data source

[rsanya]

Hi, 

I am trying to pass a list of email address from an excel file to recipients variable in PowerAppsNotification.SendPushNotification.

Is there any way I can do that?

Thanks.

[mdevaney · Accepted solution]

@rsanya 

In general, a PowerApps push notifcation call looks like this:

PowerAppsNotification.SendPushNotification(
	{
		recipients: ["email1@contoso.com", "email2@contoso.com"],
		message: "message in the notif toast",
		params: Table({key:"notificationKey", value:"The value for notificationKey"}),
		openApp: true
 	}
)

You can use your own list of emails from an Excel table column like this:

PowerAppsNotification.SendPushNotification(
	{
		recipients: RenameColumns(YourExcelTable.YourExcelColumn, "YourExcelColumn","Value"),
		message: "message in the notif toast",
		params: Table({key:"notificationKey", value:"The value for notificationKey"}),
		openApp: true
 	}
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[rsanya]

Thanks! It worked.