cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shoebwk
Helper III
Helper III

Filter command with ShowColumn

Hello Geeks,

 

Need help to filter the showColumns function data with field 'Status' ="Available".

ShowColumn(VehicleMaster,"Model","Rate")

2 ACCEPTED SOLUTIONS

Accepted Solutions
mdevaney
Super User
Super User

@shoebwk 
If Status is a Choices type column in SharePoint do this:

 

ShowColumns(Filter(VehicleMaster, Status.Value="Available"),"Model","Rate")

 

 

Otherwise, do this:

 

ShowColumns(Filter(VehicleMaster, Status="Available"),"Model","Rate")

 

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

@shoebwk 

I have corrected my small syntax error above.  Please Accept as Solution for my response above 🙂

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@shoebwk 
If Status is a Choices type column in SharePoint do this:

 

ShowColumns(Filter(VehicleMaster, Status.Value="Available"),"Model","Rate")

 

 

Otherwise, do this:

 

ShowColumns(Filter(VehicleMaster, Status="Available"),"Model","Rate")

 

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

v-qiaqi-msft
Community Support
Community Support

Hi@shoebwk,

Could you please share more about your scenario?

Do you want to filter the "Model" and "Rate" based on the Status field value?

Is there a Gallery for your filtering? I assume that you use the Gallery to filter the columns.

@mdevaney has provided the correct direction, however, there is a small error with syntax. It is ShowColumns() rather than ShowColumn().

Please set the Items property of the Gallery as below:

 

ShowColumns(Filter(VehicleMaster,Status="Available"),"Model","Rate")

 

If the Status is a Choice column, modify the formula as below:

ShowColumns(Filter(VehicleMaster,Status.Value="Available"),"Model","Rate")

If you could not solve the problem, please provide more details.

Best Regards,

Qi

Best Regards,
Qi

@shoebwk 

I have corrected my small syntax error above.  Please Accept as Solution for my response above 🙂

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,548)