Answered

Display two additional fields associated with a lookup on a canvas app

(0) Share

Report

Posted on by koneill2020

All,

How is it possible to display two additional fields associated with a lookup on a canvas app.

I have one main vendor lookup column where I've checked off two additional column fields to be associated with this lookup vendor number and vendor id

On the Powerapp - when I add the vendor lookup to the canvas app it populates fine but I want the vendor number and vendor id to also display on the canvas app and they don't populate.

The card for the vendor number and vendor id are as such:

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

rpersad 776 on at

Like (0)

Report

Can you share the LookUp function you are using to get the Vendor ID and Number in the default property of the cards.

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report

@rpersad - Sure in the default datacard I have the following:

and

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report

Just to confirm, the Vendor has been submitted into the database is the vendor information you want to display is selected in the app?

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report

@rpersad Correct - the vendor name which is the main lookup and the additional fields for the vendor id and vendor number as part of the lookup have been populated.
Where I am running into issue is in the PowerApp when I select the vendor name from the drop down the fields for the vendor id and vendor number do not populate or display.

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report

Given you are using the ThisItem function which would reference the record from your DataSource. If you would like to get the vendor's ID and number from the selected vendor in the dropdown box you have to reference the dropdown box instead of the record.

So to get the veondor's ID instead of, ThisItem.'Vendor Name: Oracle ID', use {Dropdown box name}.Selected.'Vendor Name

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report

@rpersad To confirm the reference would be at the datacard level or the actual field value?
When I try the following syntax at the Default DataCard for the Oracle ID field as such - I get this error so I'm not sure on the exact syntax to utilize:
Invalid use of .
At the card value level I get the same error:

Was this reply helpful? Yes No
Verified answer

rpersad 776 on at

Like (0)

Report

Oh the curly brackets was just to represent a placeholder value for the dropdown box name. So you do not require them. You can reference the field value in this case it being the dropdown control.

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report

@rpersad Thanks finally got this to work after following your steps and adding a dropdown box in the datacard control then the items displayed.

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report

No problem glad I could help

Was this reply helpful? Yes No