how to filter get items powerapps trigger

(0) Share

Report

Posted on by Kareem_Shamel

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?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kareem_Shamel 97 on at

Like (0)

Report

@DeepakS
Yes please can you explain to me how to do this?

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kareem_Shamel 97 on at

Like (0)

Report

My department column is a dropdown menu, can I use it or it needs to be an input text?

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kareem_Shamel 97 on at

Like (0)

Report

@DeepakS

For a reason my email does not return any item. It's empty.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No