How to filter data in Combobox on sharepoint form using powerapp

[priyankbhat]

Hi

I have developed sharepoint with 2 Sharepoint list. 

1. Project Profile

2. Status report

Status report has field "Project ID" which lookups value from Project Profile sharepoint list. See below screenshots.

I am trying to create form using PowerApps. I would like to have Project ID dropdown on newly created Status Report entry form to be filtered with data related to logged in user. 

I have tried few example and updated property named "Item" with below code

Filter(Choices('Status Report'.Project_x0020_ID), Author.DisplayName = User().FullName)

Above does not work and does not display any data.

So i tried below 

Filter(Choices('Status Report'.Project_x0020_ID), Author.DisplayName <> User().FullName)

Above displayes All Data and filter does not work.

I am struggling to get solution on filtering ComboBox which should populate data related to logged in user only.

Please suggest/help on how to fix this issue.

Thanks

Priyank

[v-xida-msft · Accepted solution]

Hi @priyankbhat,

Do you want to filter Project ID (within "Project Profile" list) related to the current login in user within the Combo box control?

I think there is something issue with the formula that you provided, I have made a test on my side, please take a try with the following workaround:

• Add the 'Project Profile' list as a data source within your app.
• Unlock the Data card control (Project ID data card) which contains the Combo box control within the Edit form.
• Set the Items property of the Combo box control to following formula:

Filter('Project Profile',Author.Email=User().Email).Project_x0020_ID

In addition, if the Combo box doesn't show any data within it based on above formula (I think it is correct), please take a try to convert the Combo box control within the Edit form into a Drop down control.

More details about converting a Combo box control within a Edit form into a Drop down control, please check the following GIF image:

Best regards,

Kris