Answered

Filter a Gallery Column that has both numbers and text

(0) Share

Report

Posted on by bfolliard

Hi all,

Have hit a roadblock and looking to phone an expert. I am connected to an Excel table (tbl_Project_Task) with ~30K rows of data. I have created a gallery and am trying to filter it down based on a search text input box(Text_Project). Depending on approach, I have run into one of two issues: Either 1) I have a delegation issue where it cannot filter for data down the data set or 2) when I type a number into the search text box it does not read it correctly.

I have tried the below:

Filter(tbl_Project_Task,StartsWith(Source_Task_Reference,TextProject.Text)) - this allows me to filter on all the data but does not allow me to filter by number when I type it in.
Filter(tbl_Project_Task,StartsWith(Text(Source_Task_Reference),TextProject.Text))) - this allows me to filter on number but does not allow me to filter on data down the data set (row 2K)
Filter(AddColumns(tbl_Project_Task,"_project",SOURCE_TASK_REFERENCE),StartsWith(SOURCE_TASK_REFERENCE,TextProject.Text)) - this allows me to filter on number but does not allow me to filter on data down the data set (row 2K)
ClearCollect(TableProject,AddColumns(tbl_Project_Task,"SourceProject",Text(SOURCE_TASK_REFERENCE)))
then adding Filter(TableProject,StartsWith(SourceProject,TextProject.Text)) - does not allow me to filter data down the data set (row 2K)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi!

Unfortunately, excel doesn't seem to be delegable within powerapps, so most likely functions like this won't work. However, there does seem to be a workaround using a flow, as seen in this similar post

Additional information on excel and delegation:
delegation overview
excel connector

Hope this helps!

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

hi @bfolliard with that amount of data in Excel you will be hitting walls more than you wish. You will have to live with delegation or use power automate to do work for you, this is also not straightforward.

Maybe not the answer you are looking for, but may I suggest you opt for a datasource that is delegable.

I'm sure one of the members will have a solution for you tho ;).

Was this reply helpful? Yes No
bfolliard 8 on at

Like (1)

Report
Copy link

Link copied!

@rubin_boer and @madlad thanks for the responses. I have moved my data to Dataverse tables and things to be functioning better for the time being.

Was this reply helpful? Yes No