Lookup Dropdown field blank

[hong_yip]

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

[hong_yip]

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

[v-qiaqi-msft · Accepted 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

[hong_yip]

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

[v-qiaqi-msft]

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

[hong_yip]

v-qiaqi-msft 

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