Answered

Adding another data source to a Edit Form in Canvas App

(0) Share

Report

Posted on by WCKPowerPlatformNoob

I have a canvas app with an edit form that is already connected to one dtaa source. However, that source has a value that has data associated to it in another source. I need to know how to join those data sets together to render the data.

Example:

ProductID in Table 1 maps to ProductID in Table 2. Table 2 has the product name that I need to pull into the edit form, if only for display.

Any help would be greatly appreciated.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Nirav Raval (Akira28) 153 Moderator on at

Like (0)

Report

Hi WCKPowerPlatformNoob ,

Can you try using the Lookup or Addcolumns any of the methods.

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28)

Was this reply helpful? Yes No
EricParker 8 on at

Like (0)

Report

You can't add another data source but you can add a Text box inside of the form (or even outside of the form) and then execute a LookUp function to get the value from Table 2. It might look something like this:

Value (or Text) = Lookup(Table 2, ProductID = {put product ID here})

Not sure how your data is getting into your edit form, so it is not possible to give you an exact formula.

See this: Filter, Search, and LookUp functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

Dee Ramos 47 on at

Like (0)

Report

Here is how I did it:

I used a Lookup Function, for a SharePoint list:

LookUp('SECOND TABLE NAME', PRODUCTID COLUMN NAME.Value = DataCardValue7.Selected.Value, PRODUCT NAME COLUMN NAME)

LookUp('Sample Product Names', ProductID.Value = DataCardValue7.Selected.Value, ProductName)

Here is some more supporting detail:

I added the Default: LookUp('Sample Product Names', ProductID.Value = DataCardValue7.Selected.Value, ProductName)

If this answers your question, please check the box that says "Does this answer your question?"

Was this reply helpful? Yes No