I have a list below, use this formula to lookup column and put value to dropdown, but "Manager C" drop down will show empty result, how can i not show empty result
Table(LookUp(ManagersDepartment,'Manager''s Name'= "A").Dept_1,LookUp(ManagersDepartment,'Manager''s Name'= "A").Dept_2,LookUp(ManagersDepartment,'Manager''s Name'= "A").Dept_3)
Manager A dropdown result
Manager B dropdown result
Manager C dropdown result
Solved! Go to Solution.
Hi@hong_yip,
Do you want to assign a blank value within the Dropdown?
Could you please tell me a bit more about the scenario?
I have a test on my side, please take a try as below.
In my scenario, I have set the Items property of a Dropdown as below:
Filter(
Table(
{
Value: LookUp(
ManagersDepartment,
'Manager''s Name' = "A",
Dept_1
)
},
{
Value: LookUp(
ManagersDepartment,
'Manager''s Name'= "A",
Dept_2
)
}
),
!IsBlank(Value)
)
This is a correct format of a table:
Table({Value: LookUp(ManagersDepartment,'Manager''s Name' = "A",Dept_1)},{Value: LookUp(ManagersDepartment,'Manager''s Name'= "A",Dept_2)})
You should combine the Filter() with !IsBlank() to remove the blank value from the dropdown list.
Hope it could help you.
Regards,
Qi
or workaround i fill in same value use "distinct" function? Any one help and give me idea, thank you
Hi@hong_yip,
Do you want to assign a blank value within the Dropdown?
Could you please tell me a bit more about the scenario?
I have a test on my side, please take a try as below.
In my scenario, I have set the Items property of a Dropdown as below:
Filter(
Table(
{
Value: LookUp(
ManagersDepartment,
'Manager''s Name' = "A",
Dept_1
)
},
{
Value: LookUp(
ManagersDepartment,
'Manager''s Name'= "A",
Dept_2
)
}
),
!IsBlank(Value)
)
This is a correct format of a table:
Table({Value: LookUp(ManagersDepartment,'Manager''s Name' = "A",Dept_1)},{Value: LookUp(ManagersDepartment,'Manager''s Name'= "A",Dept_2)})
You should combine the Filter() with !IsBlank() to remove the blank value from the dropdown list.
Hope it could help you.
Regards,
Qi
Thx v-qiaqi-msft,
i am design app for Manager check "Report" by their Department.
Report source from sharepoint list
Some Manager have managed 1 or more department.
app base on manager login and filter by their department
Hi@hong_yip,
Have you tried my solution?
I have tested on my side and it works well.
If it could not solve your problem, please post your error message
Regards,
Qi
v-qiaqi-msft
base on your solution is success to fix problem, now I have a issue can I add "All" item for this?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
38 | |
33 |
User | Count |
---|---|
245 | |
80 | |
71 | |
69 | |
66 |