cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nicojum
Regular Visitor

varUser.FullName Dropdown filtering

Hi all,

 

I've been creating a gallery that should have personalized project dropdown for unique users (varUser.FullName). 

(User 1 sees only his/her projects, User 2 sees only his/her projects etc...)

 

Database

Sharepoint  source:''Data Output''

Sharepoint Column: ''Name'' (varUser.FullName)

Sharepoint Column: ''ProjectID'' (Manually written project names)

 

Functionality

1) Form1 identifies logged user with: varUser.FullName 

2) Form1 has a dropdown4 that shows all projects in SP ''ProjectID'' Column

3) Unique user presses submit

4) Unique user data goes to ''Name'' Column in SP and  Chosen project will go to ''ProjectID'' column

 

Problem

Unique user sees all projects in dropdown4 that are in Sharepoint ''ProjectID'' column

 

Question

How can I filter this dropdown4 so it will show me only users (varUser.FullName) own projects from Sharepoint? 

 

Example how it should work

Sharepoint has projects 1,2,3,4,5,6,7

Nicojum has been assigned to projects 5,6,7

When Nicojum uses powerapp Form1, Name ''Nicojum'' will be automatically created, he then selects dropdown4 and should only see project 5,6,7 and nothing else.

 

Thank you once again for the support and let me know if clarification is needed.

 

Happy Holidays!

 

Kind regards,

Niko

1 ACCEPTED SOLUTION

Accepted Solutions
Abhilash_Swain
Super User
Super User

Hi @nicojum ,
you can filter the ITEMS for the drop down like this Filter(Data Output, Name= User().FullName).ProjectID.
Please let me know if you need further explanation for it. ( User().FullName will give the current user Full name in power apps).

 

Hope you find this relevant and this solves your issue. Happy holidays 😊

View solution in original post

2 REPLIES 2
Abhilash_Swain
Super User
Super User

Hi @nicojum ,
you can filter the ITEMS for the drop down like this Filter(Data Output, Name= User().FullName).ProjectID.
Please let me know if you need further explanation for it. ( User().FullName will give the current user Full name in power apps).

 

Hope you find this relevant and this solves your issue. Happy holidays 😊

nicojum
Regular Visitor

Thank you for the prompt reply Abhilash_Swain. 

 

It is working fine now after implementing your solution.

I forgot to mention that I'm using Distinct command as well so I had to test couple times to get it fully working. 

 

1)Distinct(Data Output, CustomerID)

+

2)Filter('Data Output', 'Name (ProjectID)' =User().FullName)

 

Final code:

Distinct(Filter('Data Output', 'Name (ProjectID)' =User().FullName), CustomerID)

 

-Niko-

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,592)