web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Applying filter on SQL...

Power Apps

Unanswered

Applying filter on SQL Server table column with data type as nvarchar

(0) Share

Report

Report

Posted on by SalilSingh

2

Hi Team,

In Power Apps, while applying filter I am unable to apply filter on a SQL Server data column whose data type is nvarchar. I need to apply filter on a column with datatype as nvarchar and text as Open, can you please provide the syntax. SQL Server table for the mentioned column I have imported in the power app.

Thanks,

Salil

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SalilSingh

There is nothing in Power Apps that prevents us from applying a filter condition to an nvarchar column. This is the syntax that you would use.

Filter(YourSQLTable, TargetColumn = "Open" )
MeravPazgas 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
nvarchar fields do not filtered when writing 2 Hebrew words or hebrew word and a number.
why?
ClearCollect(
    tblFilterHubs,
    Sort(
        Filter(
            'ods.HubAndDest',
            (txtSrcCustName.Text in CUSTNAME && txtSrcCustDes.Text in custDes && txtSrcAddress.Text in ADDRESS && txtSrcCity.Text in ZPAZ_CITYNAME &&
                     txtSrcStreet.Text in ZPAZ_STREETNAME && txtSrcDistrict.Text in DISTRICTDES)
        ),
        ZPAZ_CITYNAME,
        SortOrder.Descending
    )
);

Join the conversation