Unanswered

Unabel to convert table type to text in filter function

(0) Share

Report

Posted on by jv123

226

text conversion is not working. Assistance with syntax. The examples provided are not successful. Type mismatch persists. ProjType is a table and the dropdown4.selected.title of text.

Filter(BillngTsks, ProjType.value=Dropdown4.Selected.Title)

Different variations I have tried:

Filter(BillngTsks, Text(ProjType.value)=Dropdown4.Selected.Title)

Filter(BillngTsks, ProjType.value.Text=Dropdown4.Selected.Title)

etc. etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I'm a bit confused... you are filtering the data source BillngTsks. What is it you are trying to do with the ProjType table? You can't filter a table by another table

Was this reply helpful? Yes No
jv123 226 on at

Like (0)

Report
Copy link

Link copied!

I'm filtering a table (billingtsks) where the column projType value is equal to a drop-down value.

Was this reply helpful? Yes No
jv123 226 on at

Like (0)

Report
Copy link

Link copied!

I'm filtering a table (billingtsks) where the column projType value is equal to a drop-down value.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I see! Thanks for the additional info. First make sure the dropdown shows only the value you are trying to lookup.

Dropdown4 Items

ShowColumns(BillngTsks, "ProjType")

Now the filter can be

Filter(BillngTsks, ProjType = Dropdown4.Selected.ProjType)

Here is the result when I tested it:

Was this reply helpful? Yes No
jv123 226 on at

Like (0)

Report
Copy link

Link copied!
Ok I didn't get past the first filter. When I use:
ShowColumns(BillngTsks, "ProjType")
There is no error but nothings shows.
The Projtype column is a choice column so maybe that is the problem with this solution and a different syntax is needed.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
For a choice column, try
Choices([@BillngTsks].ProjType)

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @jv123

Ok I was able to test this. For your dropdown use:
Choices([@BillngTsks].ProjType)
The problem with the choice column is that it returns a table (the ID and the value). So we need to look for that value only. For your filter try this:
Filter([@BillngTsks],ProjType.Value = Text(Dropdown4.Selected.Value))

I tested this with a choices column and it worked to filter based on the dropdown 👍

Was this reply helpful? Yes No