Specifying which Column to show as value for dropdown

[Janne]

Hi guys,

I am currently building my first App in Power Apps.
I have created a dropdown which contains the following code in the Items field:

Filter(

    'Consultant - Projekt Zuordnungen';

    Consultant.'Consultant Mail' = User().Email && Projekt.Projektstatus = 0)

The thing is, the first Column of the 'Consultant - Projekt Zuordnungen' Table is an ID Column. I would prefer the dropdown to show the Values of the "Projekt" Column instead of the ID column.
For your information, the "Projekt" column is also a column created by a relation to the "Projektname" column of the "Projekte" Table.

I would apreciate any help.
Thank you in advance!

[FLMike]

Hello @Janne 

On your screen, when you select the combo or drop down, on the far right in your properties, first tab, it says EDIT in blue.

Click that and change it.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[M_Ali_SZ365]

could you please write this code in the display mode of the dropdown? 

["Projekt.Projektname"]

let me know if it works 

[Janne]

Hi @M_Ali_SZ365 ,
this didn't work. Thank you for the quick response though.

[Janne]

Hi @FLMike,
if you are talking about the option in the screenshot below,this doesn't work, as "Projekt" doesn't show as an option to select.
If you were talking about something else, please clarify.

[FLMike]

@Janne 

Please do as mine says, thats almost assuredly the issue, as its how it works by default.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[FLMike]

@Janne 

So you want to show the value of a LookUp? 

If that's the case, not sure I follow. What if 10 things use the same value. Is there something else you want to get out of it? Just want to make sure I help you show what you want.

Do you want a unique list of the Projects? I see its sort of based on the open projects maybe?

Also is this SharePoint or Dataverse ?

[Janne]

@FLMike 
First of all, this is dataverse.
What this table basicaly does is connect different users to the projects in the "Projekte" table and store a value of how many hours they are allowed to work on the connected project.
This means that there might be multiple rows for the same project. They all differ in the User though.
This is why I filter the dropdown for the loged in user. Every user is only supposed to see the projects connected to them.

[FLMike]

Hi @Janne 

Ahhh that makes sense more knowing you want to filter by logged in user (their projects). I am a little confused by why you have a Projects column in the Constant Table, since you wanted a 1-M so you could list all the projects.

If you have in the consultants side, then you created a Many - 1, which would be the wrong direction.

I apologize if I missed something but I assumed its a 1-M from Consultant Table to Projects, where 1 consultant has many Projects. But in your ask you said you wanted to get to the Project Table in the Consultant

Table, so you could list all their projects. But it doesn't work that way. Or I am missing something.

If you could share your data model it would help.

Ask: You want a dropdown to have all the projects that a Consultant is on.

Assumption 1: That there is only 1 record in the Consultant Table per consultant

Assumption 2: you would have a 1-M from Consultants to Projects

Here you go.

I created a Table Called Consultants, with Email as the Primary Column

-I created a simple text column called Full Name

-I created a 1-M relationship to my Projects Table called Consultant, which is linked through the Email, since its the Primary column

                                        (this shows up though on the Project table though)

I created a Table Called Projects

-I created a simple text Column called Project Title

-I created a numeric for the Project Status

-And of course the Consultant LookUp Appears

I created an App and added my new 2 tables

I have a screen with a Drop Down on it that lists my Projects.

I filter based on the logged in Users Email

Items Property = 

Filter(Projects, Consultant.Email = User().Email And 'Project Status' = 0)

And with this since I am logged I only have 1 project assigned to me that has a Status of 0

Thats how you build the data model and relationship etc to Filter all Projects, assigned to a Consultant, by Email

And now you can pick any of the Projects Properties, instead of Consultant

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Janne]

Thank you for the extensive explanation.
Sadly you made some wrong asumtions though.
Let me try to explain in more detail.

I created a project table which contains every project with related information.
I also have a consultants table which contains every consultant with related information.
I also have a third table. Both tables aboth conect to this table with a one to many relationship. I created this so I can connect multiple consultants to every project while also specifying the amount of hours each consultant is allowed to work on each project he is asigned to. Some projects also have multiple consultants.
The primary column of the third table is an ID. 
The drop down refers to this third table and curerntly shows the ID. I want it to show the Project column value though, which is the collumn of the one to many relation from projects to the third table.

Thank you for your extensive help!