You’re offline. This is a read only version of the page.
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:
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?
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:
Share
Report
All responses (
Answers (
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.
