web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Display lookup value i...

Power Apps

Answered

Display lookup value in dropdown, filtered on another lookup column

(1) Share

Report

Report

Posted on by schmucker

19

I only want to show projects in a dropdown in which the current user of the app is a part of.

My setup (build in Dataverse):

Table "Projects" where each project are stored, [ProjectName]; [ProjectID]; [Projectmanager]; ect.

Table "User" - standard table with user information

Table "Projectmembers" where each project member in the projects are stored with columns:

[ProjectID] - lookup to table Projects
[Projectmember] - lookup to table User

Variable: Set(currentUser,User());

The task is a dropdown or combo box where the user only can select projects of which they are a member of (single select).

The function should be something like, which of course does not work:

Filter(Choices([@Projectmembers].ProjectID).'Project Name',ThisRecord.Projectmember.FullName=currentUser.FullName)

Maybe a completely different setup is needed to make it work? I thought it should be pretty simple, so what am I missing here?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @schmucker ,

In this case, we always need to clarify the logic first. As you are using Dataverse and based on your description, in Projectmembers table one project should be with multiple members. So you will be able to get all projects by following formula:

Filter(Projectmembers, Projectmember.'Full Name' = currentUser.FullName).ProjectID

You can try and use it for Items of Dropdown or Combo box and set the desired display field.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No

Join the conversation