CDS Lookup field and filter in Canvas app

(0) Share

Report

Posted on by MagnusGöransson

424

Hello,

I am trying to populate a dropdown box in a Papps Canvas app.

I have one entity that have two lookup fields to the users entity. My entity name is "Coaching Pair" and the lookup fields are "Coached" and "CoachedBy".

In my dropdown i would like to list the ones that i'm a coach for.

Filter('Coaching Pair', CoachedBy.'Primary Email' = "magnus.goransson@altitude365.com")

The above works perfect, but it gives me only the autonumber names from the Coaching Pair entity. I would like to populate the dropdown with the Coached lookup field.

I have tested this:

Filter('Coaching Pair', CoachedBy.'Primary Email' = "magnus.goransson@altitude365.com").Coached.'Primary Email'

However, that gives me two blank options in the dropdown.

Is there any way to solve this?

/Magnus

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-siky-msft on at

Like (1)

Report
@MagnusGöransson

It is not supported to lookup twice in combo box.
As an alternative workaround, I suggest you use gallery to display the primary email of Coached field.
Set the Items property of gallery:
Filter('Coaching Pair', CoachedBy.'Primary Email' = "magnus.goransson@altitude365.com")
Set the Label Text in gallery:
ThisItem.Coached.'Primary Email'
Sik

Was this reply helpful? Yes No
MagnusGöransson 424 on at

Like (0)

Report

Hello,
Thanks for your answer!
Gallery works perfect! However, is there any documentation stating what works and what not when it comes to Canvas and CDS? Now it's trail and error for each control.
/Magnus

Was this reply helpful? Yes No
v-siky-msft on at

Like (1)

Report

@MagnusGöransson

Sorry for that, there is no such detailed document.
What all users can get are PowerApps documents and Blogs, they are instructional articles, but it's not guaranteed to include all the user guides, it's more from experience, and that's what the forum is all about for us to exchange experience.
Sik

Was this reply helpful? Yes No
MagnusGöransson 424 on at

Like (0)

Report

Thanks!
You doing all good with the forum. Very helpful!
/Magnus

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

@MagnusGöransson

One more thing. Kindly remind, don't expose email or other private information on the forum, whether it's work account or test account.
Sik

Was this reply helpful? Yes No
MagnusGöransson 424 on at

Like (0)

Report

Good point, I missed that. However, my email address is quite easy to find anyway 🙂

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

@MagnusGöransson

Aha, that's my occupational disease.
Have a nice day.
Sik

Was this reply helpful? Yes No