Unanswered

How to Retrieve and Send Notification to Specific Approver Based on Department and Section in Power Apps?

(1) Share

Report

Posted on by htet-htet

Hello Power Apps Community,

I have created a Power Apps form that includes dropdowns for selecting the department and section. My goal is to send a notification to the appropriate approver based on the selected department and section. Here's an overview of my setup:

Form: Includes dropdowns for department and section.
SharePoint List ("Approval Matrix"): Contains columns for Department, Section, Approver Name, and Approver Email.

What I need to achieve:

When a user selects a department and section in the form, I want to look up the corresponding approver's email from the "Approval Matrix" SharePoint list.
Use the Power Apps Notification V2 connector to send a notification to the retrieved approver's email.

Challenges I'm facing:

My organization has multiple departments and sections, resulting in many possible approvers.
I am unsure how to accurately retrieve the approver's email based on the selected department and section from the form.

What I've tried so far:

Configured the dropdowns and set up the SharePoint list.
Attempted to use the Power Apps Notification V2 connector, but I am having trouble with the logic to match the selected department and section with the corresponding approver email.

Could someone guide me on how to achieve this in Power Apps? Any examples, formulas, or step-by-step instructions would be greatly appreciated.

Thank you in advance for your help!

I got this error PowerAppsNotificationV2.SendPushNotificationV2 failed: {"error": {"code": "invalidPrincipleIDorMail",
"message": "The recipient 'approverEmail' is not a recognized email address or object identifier in the directory".

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

VeGETzX 367 on at

Like (1)

Report
Copy link

Link copied!
To fix error you facing, I assume that 'Approvers Text' column in your 'Approval Matrix' list is a text column that contain email of approver who should receive push notification.

The Set() approverEmail may look like this

Set( approverEmail, [LookUp( 'Approval Matrix', Department.Value = DataCardValue11_1.Selected.Value && Section. Value = DataCardValue18_1.Selected.Value, 'Approvers Text' )] );

and then

PowerAppsNotificationV2.SendPushNotificationV2( "Power Apps", "{appIdentifier:'d122b2da-3333-4df1-a0a7-13103def3ad0',displayName:'HR App', type:'CanvasApp'}", approverEmail, "Testing Hello World", true, ParseJSON("{}") );

And if you can put a structure of 'Approval Matrix' here with sample data, we can suggest you about accurate way to get the approvers.

Hope this help!

_______________________________________
If I have answered your question, please mark your thread as Solved.

Was this reply helpful? Yes No
htet-htet 40 on at

Like (1)

Report
Copy link

Link copied!

Hello @VeGETzX, thank you for your advice, but I still got error
this is my approval matrix sharepoint list

Was this reply helpful? Yes No
VeGETzX 367 on at

Like (1)

Report
Copy link

Link copied!

Can you share the current error you facing?

Was this reply helpful? Yes No
htet-htet 40 on at

Like (1)

Report
Copy link

Link copied!

Yes, @VeGETzX

Was this reply helpful? Yes No
VeGETzX 367 on at

Like (1)

Report
Copy link

Link copied!

It is likely that no Approval Matrix matches the condition you selected, so the LookUp() function returns an empty result. Try checking your condition.

The function should work if there is exist approver returned from the LookUp

_______________________________________
If I have answered your question, please mark your thread as Solved.

Was this reply helpful? Yes No