Multiple datasources for single form field

(0) Share

Report

Posted on by ShadowTech

Hello,

What I'm looking to accomplish:

1. I have a single form (New) that will populate a SharePoint list (Datasource1).

2. I want to be able to type in a number value into one of the fields and and have it search another datasource (SQL DATASOURCE2) then auto populate other fields in that same form with data from that source (SQL).

3. Then with that data, submit and create a new item in the SharePoint list.

Is this possible? And if so how do I go about accomplishing this task?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@ShadowTech

Yes. It is possible.

In the Power App, add both SharePoint list and SQL table as data sources.

If you are using Edit form in the Power App which connected to SharePoint list:

1. Find the datacard which has the SharePoint list column. Unlock the card.

2. Then, place a custom Drop Down control (combo box with single selection) in the data card

3. For drop down Items property, place SQL Table as data source.

4. In the datavalue field, in the Update property mention the value of above drop down selected value.

5. Hide the datavalue field by setting visible property to false.

In edit form, we should query the SQL table in the drop down to show the value in the default field.

I hope above steps are useful for you.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!

@rsaikrishna Thanks for the insight. Just to make sure what you are saying I enclosed an image to better clarify. All fields in the form are columns in the SharePoint list which some of those fields i need to be auto populated with the SQL data source data. I essentially need to use one of those fields to look up the number value (invoice number) that will auto populate those designated fields. How do I match the SQL table columns (data) with the SharePoint column fields in the form as they are different? Or do they have to be the same?

Hope the image helps and thanks again for your help.

Was this reply helpful? Yes No