varUser.FullName Dropdown filtering

[nicojum]

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

[Abhilash_Swain · Accepted solution]

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]

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-