Power Platform Community Forum Thread Details

The following code works properly, except that the collection shows that commentsOCA column is labeled 'field_1', and comments field is labeled 'field_2'. Title is labeled correctly. How do I fix this?

ClearCollect(
    colFilteredComments,
    ShowColumns(
        Sort(
            Filter(
                FirstN(
                    PassOnComments,
                    2000
                ),
                Lower(txtSearch.Text) in Lower(comments) || Lower(txtSearch.Text) in Lower(commentsOCA)
            ),
            Title,
            SortOrder.Descending
        ),
        Title,         
        commentsOCA,
        comments
    )
);

Categories:

Building Power Apps

Hi Reefguy

Unfortunately, you have created your list initially from Excel and this process creates the "underlying" field names with the field_x schema. There is no way of changing/fixing this after the list has been created. You can create a new list with the field names you need (for other reasons, settle on these and do not change them). You can then import the existing data (copy/paste into a grid view in SharePoint or if a lot of data, you can use Power Automate to bring them in 5k at a time).

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee