web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter arrayed SQL col...

Power Apps

Answered

Filter arrayed SQL column in PowerApp

(0) Share

Report

Report

Posted on by Raif8522

19

Hi everyone,

i am tring to figure out how to filter a SQL Table column, which have array of values, based on Label on Canvas App.

Gallery below has SQL table as a Datasouce, and i would like to filter based on the column(ColumnA) where has array of numbers.

On the Canvas app, LabelA has dynamic values where it can be one of the number on ColumnA.

i used "Startwith", it is working if the number on LabelA is 73928189 but doesn't work if the number is "616258804" is there anyway i can do overcome this problem please?

Filter(SQLDB,startswith(ColumnA,LabelA.Text))

Thansk

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Raif8522 ,

You could try

Filter(SQLDB,LabelA.Text in ColumnA)

In addition, cause 'in' is not delegable , this formula is not delegable. If the number of records in SQLDB is more than 500 and less than 2000 , please set the data row limit to 2000.

If the number of records in SQLDB is more than 2000, then starting from the 2001st record, all subsequent records cannot be obtained.

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation