cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JensVolswinkler
Regular Visitor

Powerapps Filter a Sharepoint-List for a Gallery

Hi,

I have a Sharepoint-List and want to display data in two galleries.

 

The first gallerie uses a filter on columns like date and price and it works:

Filter(Sharepointlist; Date<=(SelectedEndDate) ; Date>=SelectedStartDate;Value(Price) > 0)

 

For the second gallery I want to filter by the title.

A title could look like: 12345Prämie

And I try to filter it with the following code:

Filter(RechnungenXML; Zahldatum = DatePrämie; NamePrämie exactin Titel)

 

DatePrämie and NamePrämie are both variables with date / text.

 

However my second gallery is empty.

Also I have a warning in my code that the filter might not work on big datasets....are there any alternatives to "exactin"?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Yes the Coll in collRechnungenXML is a collection. The exactin is not delegable so the idea is to pull the table into a collection first. Then you can apply your exactin fourmula.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

View solution in original post

5 REPLIES 5
eka24
Super User
Super User

I suggest the With function:

With({collRechnungenXML; RechnungenXML};

Filter(collRechnungenXML; Zahldatum = DatePrämie; NamePrämie exactin Titel))

 

I believe NamePrämie is a text not a column

With function in Power Apps - Power Apps | Microsoft Docs

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

What does the "coll" in collRechnungenXML mean?

 

coll = Collection ? 

 

And yes NamePrämie is a text.

 

Hi @JensVolswinkler 
collRechnungenXML its variable just copy to your gallery item properties  as @eka24 stated 

 

 

 

 

 

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-with

Thank you
If this post helps, then please consider Accept it as the solution to help the others and consider giving it a "Thumbs Up."

Yes the Coll in collRechnungenXML is a collection. The exactin is not delegable so the idea is to pull the table into a collection first. Then you can apply your exactin fourmula.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

View solution in original post

JensVolswinkler
Regular Visitor

@eka24  @Ramole  Thanks for your answers!

 

I created a collection and filtered it in the app since (as I learned) exactin is not delegable.

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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.

Users online (1,494)