SQL Query from Power Apps using Flow (Tutorial)

Опубликовано: 06 Август 2019
на канале: Dave's Tech Tips

54,968

373

In this Microsoft PowerApps video Tutorial we look at how to query SQL tables from PowerApps and more specifically by using the infamous 'in' operator against a string 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'),'"',''''),',',''',''')

Because this is not yet available for on-premises SQL servers, another video shows how to do the same using Stored Procedures, which is supported from Flow to on-premises SQL servers through the data gateway:
• PowerApps - Pass string array to SQL Store...

На этой странице сайта вы можете посмотреть видео онлайн SQL Query from Power Apps using Flow (Tutorial) длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Dave's Tech Tips 06 Август 2019, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 54,968 раз и оно понравилось 373 зрителям. Приятного просмотра!

54,509

1 тыс