News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows how to filter get item...

Power Automate - Using Flows

Answered

how to filter get items powerapps trigger

(0) Share

Report

Report

Posted on by Kareem_Shamel

97

Good Day,

I have an Email that sends an HTML table created in power automate flow.

I want to filter the items sent by department depending on the user entry in the powerapps.

Any idea how this can be done by flow?

All responses Img

All responses (7)

Answers Img

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Re: how to filter get items powerapps trigger

Hi @Kareem_Shamel ,

It appears that you have found a solution to your issue!

https://powerusers.microsoft.com/t5/Using-Flows/filter-not-working/td-p/500553

When we configure the parameters passed by Power Apps, we need to ensure we have assigned an expected value for the parameter in Power Apps.

Please refer to this good example to get more details about adding a flow to Power Apps:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Besides, if you find that solution to be satisfactory, please go ahead and click "Accept as Solution" so that this thread will be marked for other users to easily identify!

Thanks for being an active Microsoft Flow Community Member!

Best Regards,
Kareem_Shamel 97 on at

Like (0)

Report

Re: how to filter get items powerapps trigger

@DeepakS

For a reason my email does not return any item. It's empty.
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: how to filter get items powerapps trigger

Hi @Kareem_Shamel

You can use any type , just pass the value form the drop down column.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Kareem_Shamel 97 on at

Like (0)

Report

Re: how to filter get items powerapps trigger

My department column is a dropdown menu, can I use it or it needs to be an input text?
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: how to filter get items powerapps trigger

Hi @Kareem_Shamel
Here are few screen capture on how you can achieve this:

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Kareem_Shamel 97 on at

Like (0)

Report

Re: how to filter get items powerapps trigger

@DeepakS
Yes please can you explain to me how to do this?
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: how to filter get items powerapps trigger

Hi @Kareem_Shamel

You should get the department name from Power Apps (ask in power apps) and use it as filter query in power automate to filter the data (Filter query - Department eq 'departmentname'.

Let me know you have question on how to do this?

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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,596 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,928 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans