Filter DataTable based on DataField

(0) Share

Report

Posted on by TWolsten

108

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (2)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

Since I can't see your form I am just taking a guess. It looks like you are referencing the data card and not the field inside the card. Out of the box the field name would be something like DatCardValue1.

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report

Thank you for the help!

I managed to get a little further but it is still not 100% working.

Filter(bp_changelog, DataCardValue1.Text = Title)

If I change Filter for Search it works but as the list is more than 500 I would need the Filter function to work.

Any ideas why the above would be working?

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report

Hope someone has an idea of the issue =(

Any help would be greatly appreciated!

Was this reply helpful? Yes No
ThatAPIGuy 925 on at

Like (0)

Report

@TWolsten

Try this

Filter(bp_changelog, Title = DataCardValue1.Text )

If I understand right, you are filtering the rows where the Title column of bp_changelog is equal to the datacardvalue1.text

hope this helps

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report

Yes, that is exactly what I am trying to acheive.

I have tried your solution but it brings back a black DataTable.

Would the values in the DataCareValue matter as they vary. For example some are like 760-1, RLW111111 & GEO123456?

Was this reply helpful? Yes No
ThatAPIGuy 925 on at

Like (0)

Report

It should filter , irrespective of the values.

Do you mind sharing some screenshots? so that I can understand better.

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report

Hi vivekb,

Here is a screenshot which I have annotated that hopefully helps where information is being stored.

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (2)

Report
According to the documentation the Filter function doesn't work with Data Tables at this time.
Data table control in PowerApps look under "Not yet available"

You could try and use the search function.
Search(bp_changelog, DataCardValue1.Text, "Title")

Was this reply helpful? Yes No
TWolsten 108 on at

Like (0)

Report

Not the best news but thank you for getting to the bottom as to why it was not working.

Search function would not suffice due to it not being under delegation. Maybe something to submit to the PowerApps team.

Thank you for all the help!

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report

@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

Was this reply helpful? Yes No