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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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