News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows send notification to s...

Power Automate - Using Flows

Unanswered

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

(0) Share

Report

Report

Posted on by Community Power Pla...

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.

All responses Img

All responses (1)

Answers Img

Answers (0)

iltoningui 247 on at

Like (0)

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

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,524 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans