web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate send notification to s...

Power Automate

Unanswered

send notification to specific team depending on company field of a user

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I am new to PowerAutomate, I hope I describe my question clear.

I have about 20 Teams like this:

Team	Mail
CompanyA	team1@mail.com
CompanyAB	team1@mail.com
CompanyC	team2@mail.com

Depending on the users company fielt of AzureAD I want to send a notification to the proper team.

I am looking for something like:

- if users company contains "CompanyA" then "team1@mail.com" and so on...

I (successfully) made a flow with conditions but I guess having 20 if then queries is not the useful way and managing is a real pain.

Do you have an advice for me?

Thanks in advance for your thoughts.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

iltoningui 247 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous
You will have to store the company and emails data somewhere like SharePoint or statically in the flow.
I'm using a static list in a flow

I'm Creating a company field, similar to the information you would find in the user Company field.
I'm creating a JSON List to store a list of object with Company and Email field, similar to what a SharePoint or other list
Filter the list by CompanyA this will return a list with one element.
Get the Email of the first object returned from the filter array action.
@{first(body('Filter_array'))?['Email']}
There you have the email and no if conditions

Hope this helps
If so, consider marking this post as solved

Was this reply helpful? Yes No

Join the conversation