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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Building Power Flow us...
Power Apps
Answered

Building Power Flow using Dataverse Table

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I have table(User Management) in Dataverse like below.

DBK2_0-1653980211053.png

Now i Need to get these users in "To" based on Role to send notification.

DBK2_1-1653980361376.png

I am creating notification flows and in that I need to get Role specific users in "To" section of send email.

I want to use only If users Role is "Admin" and "IS" that needs to get and define in "To" section for particular flow and in other flow I need use RS and TS user role users. Like this way I need to define role based users in "To" for different flows. 

Can you please let me know how to get. 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    You could try to use filter array action in flow.

    I made a sample for you .

    vxiaochenmsft_0-1654141949197.png

    [
    {"Name":"Name1","Email":"Name1@test.com","Role":"Admin"},
    {"Name":"Name2","Email":"Name2@test.com","Role":"IS"},
    {"Name":"Name3","Email":"Name3@test.com","Role":"RS"}
    ]
    @or(equals(item()?['Role'], 'Admin'),equals(item()?['Role'], 'IS'))

    vxiaochenmsft_2-1654142023449.png

    vxiaochenmsft_3-1654142041408.png

    vxiaochenmsft_4-1654142058365.png

     

    Best Regards,

    Wearsky

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard