Answered

Display Lookup Value in DataCard

Like (0) Share

Report

Posted on 29 Sep 2021 11:41:03 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:

General Questions

I have the same question (0)

All responses (9)

Answers (1)

AV4 11 on 01 Sep 2023 at 07:52:51

Like (0)

Report

Re: Display Lookup Value in DataCard

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
alexa_028 63 on 10 Jul 2023 at 13:34:13

Like (1)

Report

Re: Display Lookup Value in DataCard

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
eftichia 34 on 28 Jul 2022 at 12:51:53

Like (0)

Report

Re: Display Lookup Value in DataCard

Hi,
Can you provide the formula?

Thanks

Was this reply helpful? Yes No
buzzen 80 on 30 Sep 2021 at 09:37:10

Like (1)

Report

Re: Display Lookup Value in DataCard

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
buzzen 80 on 29 Sep 2021 at 12:46:57

Like (0)

Report

Re: Display Lookup Value in DataCard

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
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on 29 Sep 2021 at 12:46:08

Like (2)

Report
Re: Display Lookup Value in DataCard

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
Nogueira1306 7,390 Super User 2024 Season 1 on 29 Sep 2021 at 12:26:46

Like (0)

Report

Re: Display Lookup Value in DataCard

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
buzzen 80 on 29 Sep 2021 at 12:21:29

Like (0)

Report

Re: Display Lookup Value in DataCard

Unfortunatly that doesn't work....

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on 29 Sep 2021 at 11:45:21

Like (0)

Report

Re: Display Lookup Value in DataCard

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