Hello,
I'm creating an issue register canvas app where one column shows the project number(s) that a particular issue could impact. I would like to filter my data table by project number based on a dropdown box.
Example of data table column
I tried filtering with the following code, however I ran into the issue of the column entry values being tables and the dropdown entry values being text and thus incompatible for searching. I thought that perhaps I could search for each index within the table though I'm not sure how to do this in PowerApps.
('Project No'.Value = ProjectNumberFilterInput.Selected.Value || ProjectNumberFilterInput.Selected.Value = Blank())
My second approach was to convert each column entry to a string and then filter them with the StartsWith() function. Although this works, project numbers can be entered in any order and thus only entries that start with the project number entered in the filter box will be let through the filter. i.e. in the case of the above screenshot, selecting J108300 would not display the first, second, and third entries.
StartsWith(Concat('Project No', Value, ", "), Text(ProjectNumberFilterInput.Selected.Value))
This approach also causes delegation issues which disqualifies it and so I didn't spend any additional time refining it.
Any ideas?
