web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to add another col...

Power Apps

Answered

How to add another column in a filter

(0) Share

Report

Report

Posted on by MiteshGovan

341

Hi

How do you add another column but I want it to filter by staff. Please see the image below.

Sort(Filter('Medical',Status=Dropdown1.Selected.Value),ID,Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MiteshGovan,

Based on the issue that you mentioned, do you want to filter by a specific visitor based on your existing formula?

Could you please share a bit more about the scenario?

Sort(Filter('Medical',Status=Dropdown1.Selected.Value, Visitor="STAFF"),ID,Descending)

Or if your Status column is a Choice type, please try the following one:

Sort(Filter('Medical',Status.Value=Dropdown1.Selected.Value, Visitor="STAFF"),ID,Descending)

Was this reply helpful? Yes No
MiteshGovan 341 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Thank you

Was this reply helpful? Yes No

Join the conversation