cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Delegable Data Source - SQL - In Operator Service Limitation

So according to the PowerApps knowledge base the 'in' operator is delegable with SQL as a data source. So why doesn't this work:
In a gallery (search box text as number type)
Filter('fgaslogs',searchbox.text in JobNo)

It returns incomplete results and the 'in' operator is underlined in blue stating service limitation - highlighted operation is not supported by column 'JobNo'

JobNo data type in sql is int
3 REPLIES 3
Super User
Super User

Re: Delegable Data Source - SQL - In Operator Service Limitation

Hi

 

It is sometimes good to have trial and error because the tutorial reference may miss out something.

Why not try on

- = ?

 

TQ

hpkeong
Super User
Super User

Re: Delegable Data Source - SQL - In Operator Service Limitation

Sorry for my naivety but I don't understand what you are saying: 'why not try on - = ?'
Super User
Super User

Re: Delegable Data Source - SQL - In Operator Service Limitation

Hi @Delid4ve

 

Apolgize, I mean try using "=".

TQ

hpkeong

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 55 members 4,396 guests
Please welcome our newest community members: