Can't convert this data type Table to Text.

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I am still seeking a remedy to the following issue.

Thank you to those who have assisted so far.

To this point, none of the recommendations have solved the problem.

I followed this video to a 'T'. The only difference I can tell is Reza is using a Person LookUp column from his
SharePoint list in his formula, and I'm trying to use a column from a collection. Everything else is working
except this one piece.

https://youtu.be/_S6BDI0Oovs

I am trying to filter Gallery1 with the formula at the bottom of this screen, but I keep getting this error on
the colShowName.Value

Can't convert this data type. Power Apps can't convert this Table to Text.

The colShowName.Value is coming from a Checkbox control in Gallery2.

The 'Items' of Gallery2 has -

SortByColumns(
   Distinct(
      col_Event_Data_Collection,
      Show_Name
   ),
   "Value",
   SortOrder.Ascending
)

 

The 'OnCheck' of the Checkbox in Gallery2 has -

I have tried multiple configuration of the below and can't get the error to clear on
colShowName.Value

What am I missing?
******************************************************************************************

Switch(Newest_to_Oldest_Gallery_Sort_Dropdown.Selected.Value,"Created: Newest to Oldest",
    Sort(
         Filter(
            col_Event_Data_Collection,
              And(
                 Or(
                    Or(
                    Keyword_Search_Fld.Text in Title,
                    Keyword_Search_Fld.Text in Venue_Name,
                    Keyword_Search_Fld.Text in Opening_Date
                ),col_Event_Data_Collection.Show_Name in colShowNames.Value
            ))),
        Created,SortOrder.Ascending),"Created: Oldest to Newest",
    Sort(
         Filter(
            col_Event_Data_Collection,
              And(
                 Or(
                    Or(
                    Keyword_Search_Fld.Text in Title,
                    Keyword_Search_Fld.Text in Venue_Name,
                    Keyword_Search_Fld.Text in Opening_Date
               ),col_Event_Data_Collection.Show_Name in colShowNames.Value
            ))),
        Created,SortOrder.Descending
    )
)

Categories:

Using Apps Using Formulas

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

vipuljain03 701 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
2 quick tips:

Simplify usage of And and Or in your formula - multiple Or (nested Or) not required as per your formula.

Instead of colShowNames.Value, try using Show_Name in colShowNames.Show_Name. This is the correct way to filter using a collection

Was this reply helpful? Yes No
Suggested answer

Sam_Fawzi 928 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey Phineas,

Try Replace

col_Event_Data_Collection.Show_Name in colShowNames.Value

With

col_Event_Data_Collection.Show_Name in ShowColumns(colShowNames, "Value")

ShowColumns(colShowNames, "Value") extracts only the "Value" column from colShowNames, converting it into a single-column table that can be compared with Show_Name.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply.

I've resolved the original sort/filter issue.

The problem was I was using 'Classic' controls, and this task called for 'Modern' controls.

My issue now is how to update the formula so that if no checkbox is checked and the Keyword
field is Blank/Empty then show all items.

Currently, if no box is checked and the keyword is blank/empty there is just a blank gallery.

One suggestion was to add...',Sort(col_Event_Data_Collection,Opening_Date,SortOrder.Ascending)'
between the last to close parentheses.

I tried that and still got a blank gallery.

Switch(

Newest_to_Oldest_Gallery_Sort_Dropdown.Selected.Value,

"Opening Date: Newest to Oldest",

Sort(

Filter(

col_Event_Data_Collection,

And(

Or(

Keyword_Search_Fld.Value in Venue_Name,

Keyword_Search_Fld.Value in Show_Name,

Keyword_Search_Fld.Value in Opening_Date

),

Title in colShowNames.Title

)

),

Opening_Date,

SortOrder.Descending

),

"Opening Date: Oldest to Newest",

Sort(

Filter(

col_Event_Data_Collection,

And(

Or(

Keyword_Search_Fld.Value in Venue_Name,

Keyword_Search_Fld.Value in Show_Name,

Keyword_Search_Fld.Value in Opening_Date

),

Title in colShowNames.Title

)),Opening_Date,SortOrder.Ascending))

Was this reply helpful? Yes No