cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SharePointAU
Level: Powered On

How to Autofill a table based on a Text Input that triggers a SQL Query

I have form that needs to take a value via Text Input (autocomplete if possible), and auto fills other fields in the form based on a SQL query. The query joins several tables to get the data. Is that possible, and if not how should I go about collecting that data to use?

1 ACCEPTED SOLUTION

Accepted Solutions
SharePointAU
Level: Powered On

Re: How to Autofill a table based on a Text Input that triggers a SQL Query

Thank you for your response. I am not asking how to see the View. I literally meant to use a SQL Query. 

However, I have since figured this out that where I have trouble "joining" tables, i can simply lookup the keys and hide them on the page to use in Lookups for the remaining data. 

 

I now have a solution that allows me to enter a number in a text field, and auto populate other fields in my form based on SQL Data from several tables.

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to Autofill a table based on a Text Input that triggers a SQL Query

Hi @SharePointAU,

 

If the SQL Query here means the View, then currently this is not available.

There is an idea submitted on this already:

PowerApps must also see SQL Azure Queries, not only Tables

 

PowerApps by now could only work with the actual data table,  if you would like to use the data from Multiple tables, then you need to add all the related tables as data source in PowerApps.

After that, take use of the filter or Lookup function to find the proper data.

Filter, Search, and LookUp function in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SharePointAU
Level: Powered On

Re: How to Autofill a table based on a Text Input that triggers a SQL Query

Thank you for your response. I am not asking how to see the View. I literally meant to use a SQL Query. 

However, I have since figured this out that where I have trouble "joining" tables, i can simply lookup the keys and hide them on the page to use in Lookups for the remaining data. 

 

I now have a solution that allows me to enter a number in a text field, and auto populate other fields in my form based on SQL Data from several tables.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

Top Kudoed Authors
Users Online
Currently online: 392 members 5,806 guests
Please welcome our newest community members: