cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrendonBrooksP1
Post Patron
Post Patron

Filtering Items in a gallery

Greetings. I am in the process of buiding an inventory application for my company. There are multiple locations and I have made a screen for each one.

 

All the data is stored on a single table. Eventually, I will have to write a formula that adds and removes records, but one step at a time here.

 

I'm using the following formual to filter records from a  location:

    Filter('ItemDataBase';'Location' = 'name of location')

This formula displays an error.  Is there something that I'm missing here?

1 ACCEPTED SOLUTION

Accepted Solutions

Carlos,

 

My apologies for the delay. I discovered that my formula was incorrect. I used the following instead:

 

Filter( TableName, Location1 & Group1 = "NameofGroup")


Since then I have had no issues displaying anything my tables. Thank you for your assistance.

 

Brendon

View solution in original post

6 REPLIES 6
CarlosFigueira
Power Apps
Power Apps

When you hover the squiggly lines under the formula, it should display an error in the tooltip. What error do you get?

 

One thing that looks incorrect is that the single quotes (') are used for escaping names; in your formula, are you using a fixed value for the name of location? If so, you need to use double quotes ("):

Filter(ItemDataBase; Location = "name of location")

Notice also that if you don't need to escape the data source name (ItemDataBase) or the column name on which you want to filter, you don't need to use quotes to escape it.

Carlos,

 

The error that I receive is "Invalid number of arguments" when I use double quotes.

Where is this formula used, and can you post the formula that you are using now, along with the relevant columns from your data source?

Carlos,

 

My apologies for the delay. I discovered that my formula was incorrect. I used the following instead:

 

Filter( TableName, Location1 & Group1 = "NameofGroup")


Since then I have had no issues displaying anything my tables. Thank you for your assistance.

 

Brendon

View solution in original post

werner88
Frequent Visitor

i need to filter a gallery with items who have an expiring date and remove them automaticly if the post has expired

thanks for helping

werner88
Frequent Visitor




i need to filter a gallery with items who have an expiring date and remove them automaticly if the post has expired

thanks for helping

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (3,092)