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!
Solved! Go to Solution.
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")
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 -
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.
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.
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?
Hope someone has an idea of the issue =(
Any help would be greatly appreciated!
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
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.
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?
It should filter , irrespective of the values.
Do you mind sharing some screenshots? so that I can understand better.
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.
Hi vivekb,
Here is a screenshot which I have annotated that hopefully helps where information is being stored.
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")
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!
User | Count |
---|---|
137 | |
127 | |
75 | |
72 | |
69 |
User | Count |
---|---|
222 | |
135 | |
78 | |
58 | |
54 |