web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : W7apDI/SnUgMrhaM2NKTVh
Power Automate - Building Flows
Answered

Send Push notification to a specific department

Like (0) ShareShare
ReportReport
Posted on 27 Oct 2023 09:23:17 by 49

Hello

 

Im trying to make a flow that automatic sends a push notification a specific department when a new post is added im my app. if none department is selected is should send to all. 

 

i've got two sharepointlists: 

1: settings for each user:

title: is user email

Afdeling: is department,

Notifikation: is the column for the Notifications. reason for this collumn is that an employee can see post from different departments (Afdeling) but only recive notifications from the departments set by this column.

Jakob_hjort_1-1698396413524.png

2:  is the sharepoint list with the different post.

Jakob_hjort_2-1698396785818.png

right now i made a flow that sends a notification to my self everytime a post is made.

Jakob_hjort_3-1698398308102.png

Jakob_hjort_4-1698398368166.png

 

what to do?

 

Categories:
  • Verified answer
    Jakob_hjort Profile Picture
    49 on 31 Oct 2023 at 14:00:37
    Re: Send Push notification to a specific department

    Thanks for the suggestions but I made it work this way:

    Jakob_hjort_0-1698759855445.png

    Notifikation eq items('Apply_to_each')?['Value']

     

    Jakob_hjort_1-1698759945097.png

    Jakob_hjort_2-1698760019498.png

     

  • Unknown geen idee Profile Picture
    1,755 on 30 Oct 2023 at 13:56:05
    Re: Send Push notification to a specific department

    Dear J,

     

    In order for your to send a notification to a group of people/department, you either need to have the group defined within the D365 environment or have a specific list which details which users/emails/ID's belong to a group.

     

    I am not sure if the first suggestion would apply in your situation. This would be easiest method as you could just call a particular group in for example an outlook email. For example, we have a group in our Outlook in our organization which is called something like 'EMEA All' which sends an email to all staff in the EMEA organization.

     

    For the 2nd option, you have a list already. Roughly you would go through the following steps:

    1. Read the list in total, likely use a 'List rows' action. Each user has a different row.
    2. Filter the list by department (this means that if a user can only be part of 1 department, you can have 1 column which details the department. Alternatively you will have a column per department with values which dictates if a user is part of this).
    3. Use a 'Filter array' action to filter the list. 
    4. Use the output of the filter array in a loop (Apply to each).
    5. Per filtered user in the loop, send out the alert/email.

    Hope the suggestions help,

    Happy flowing,

    Koen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2