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
Solved! Go to 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:
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
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:
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
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
254 | |
207 | |
76 | |
37 | |
33 |
User | Count |
---|---|
326 | |
216 | |
124 | |
71 | |
54 |