Answered

Lookup Dropdown field blank

(0) Share

Report

Posted on by hong_yip

100

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

hong_yip 100 on at

Like
a
(0)

Report
Copy link

Link copied!

or workaround i fill in same value use "distinct" function? Any one help and give me idea, thank you

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
hong_yip 100 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
hong_yip 100 on at

Like
a
(0)

Report
Copy link

Link copied!

v-qiaqi-msft

base on your solution is success to fix problem, now I have a issue can I add "All" item for this?

Was this reply helpful? Yes No