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

Filter DataTable based on DataField

Hi all,

 

Hope you can help as I have tried to find a solution on the Boards but I must be either missing something or just having a brain freeze.

 

So I have two lists, bp_changelog and bp_live.

 

On the bp_live list ViewForm there is a ID Field (DataCard1).

 

I would like to pull the ID Field and filter the DataTable (bp_changelog) below with just the relevant IDs based on the bp_live ID Field.

 

I currenlty have:

Filter(bp_changelog, "DataCard1.Value" in Lower(Title) )

 

As my formula but the "DataCard1.Value" is the part I am struggling with as if I put a value (e.g "760-1") instead the list filters nicely.

 

Sorry for the probably simple issue but help would be greatly appreicated!

16 REPLIES 16

@TWolsten,

 

If your list is under 2,000 you could try the new feature that lets you increase the delegable row limit up to 2,000.

 

PowerApps data row limit for non-delegable queries



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

@TWolsten

 

Do you have any specific reason of using the data table instead of a gallery?

 

If not, you can format the gallery to almost like a data table -

2018-02-10 12_09_52-Test - Saved (Unpublished) - PowerApps.png

 

This way you can use filter and it will be delegable.

 

 


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have been playing around with the Data Table and I am able to get fileter to work. Are you saying the Filter formula isn't returning any values or that you want to use search but search only works on the first 500? Since the data source is SharePoint you will want to use StartsWith or "=" to avoid 500 limit.

 

Here is how you can use the StartsWith inside of a Filter:

Filter(bp_changelog, StartsWith(Title, DataCardValue1.Text))

 I set-up a test app and the other formula is working for me.

Filter(bp_changelog, DataCardValue1.Text = Title)

 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks vivekb!

 

Love the work around for the DataTable, I didnt realise you could customise the Gallery to look like that.

 

I have amanged to get it working in Gallery view and the DataTable now.

 

Thanks again.

That is odd the:

Filter(bp_changelog, DataCardValue1.Text = Title)

formula returns no values when I know there are matching values... very odd!

 

The:

Filter(bp_changelog, StartsWith(Title, DataCardValue1.Text))

forumla works but say I have 760-1, as the DataCardValue1, I also get 760-2, 760-3 & 760-4 for some reason?

 

Very odd, I have switched over to a Gallery view as this seems to be much easier to configure and the:

Filter(bp_changelog, DataCardValue1.Text = Title)

 forumla works perfectly with the Gallery.

 

Thanks again for all the help and I have no idea what is wrong with my DataTable, I am just glad the Gallery works Smiley Happy

Good Proposal! How did you get the vertical columns?

RyanXExner
Advocate II
Advocate II

FYI - We got this to work by enabling the newly released Updated Controls in the app settings: https://powerapps.microsoft.com/en-us/blog/improved-data-table-control-with-column-formulas/

 

After enabling, we were able to add the filter operation to get the value from another list.  Unfortunately, SharePoint doesn't return lookups of a lookup, so we implemented this as a workaround.

 

Hope this helps!

 

image.png

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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