Unanswered

Display Lookup Value in DataCard

(0) Share

Report

Posted on by buzzen

Hi, I've a SP list with some lookup fields... Now in the PowerApp I have a dropdown to choose something... Then it should display the corresponding values from the other SP list... first I achieved that with Labels. there it was easy: Text = Lookup('lookuplist', Value = DataCardValue.Selected.Value, 'lookuplist.column').

Now I had to redesign the form and want to use the default fields = DataCards

But there I can't use the same....

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Lookup('lookuplist', Value = DataCardValue.Selected.Value, 'lookuplist.column').FieldYouWant

Try that on default

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Was this reply helpful? Yes No
buzzen 80 on at

Like (0)

Report

Unfortunatly that doesn't work....

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Lookup('lookuplist', Value = DataCardValue.Selected.Value).FieldYouWant

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (2)

Report
Hi @buzzen ,

If there is any issue with Lookup you can also try filter function like below.
First(Filter('YourListName', ColumnName = DataCardValue.Selected.Value)).YourRequiredColumn

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
buzzen 80 on at

Like (0)

Report

Still no luck... let me explain it a bit more in detail... for example:
I have a SP List called "Countries", and a second List called "Cities".
In the SP List "Countries" I've added a lookup field called "City" that look in the "Cities" list and added more columns like "Population", "Language"...
Now in PowerApps when I add to full form of "Countries". The "City" field is a dropdown to choose a city.
Then within the DataCards "City:Population" and "City:Language" it should automatically show the corresponding value... hope I explained it clearly... 🙂

Was this reply helpful? Yes No
buzzen 80 on at

Like (1)

Report

Thanks! I was finally able to achieve what I want... But I had to change it to "ColumnName.Value"...

Was this reply helpful? Yes No
eftichia 34 on at

Like (0)

Report

Hi,
Can you provide the formula?

Thanks

Was this reply helpful? Yes No
alexa_028 63 on at

Like (1)

Report

Thanks for help , I found it useful for my scenario. Where I had a table in dataverse which I connected to form and I wanted to populate ID value based on dropdown values

Was this reply helpful? Yes No
AV4 11 on at

Like (0)

Report

Hi @PriyankaGeethik
How should this be modified to accommodate multiple selections "selecteditems"... if the Country is a multiselect Combobox.

Was this reply helpful? Yes No