cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerApps Staff Mr-Dang-MSFT
PowerApps Staff

Re: Searching on a field belonging to a reference table

I see the issue. You're attempting to Search your SQL table against a formula. You can always check if a given function is delegable in a filter or search, but my rule of thumb is that the more complicated your filter is, the less likely it is delegable. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview The good news is that you could easily create a SQL View that joins the two tables with the Company as a column added to the original table. Note that you cannot write to the view of course, but you could easily match it up with the actual record in your table since they would both have the same primary keys. https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,604)