In this video Tutorial we look at how to query SQL tables from PowerApps and more specifically by using the infamous 'in' operator against an array! Unfortunately this is not support directly from PowerApps (yet), but Flow to the rescue!
We will be using Flow to query the SQL server, and then return the data to PowerApps. It is amazing how performant this is and the amount of records that it can safely handle in the response.
If you battle to understand what I am trying to explain during the Flow expression (like me), please see below for a quick reference:
replace(replace(variables('varSearchArray'),'"',''''),',',''',''')
