cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hong_yip
Helper II
Helper II

Lookup Dropdown field blank

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)

 

 

hong_yip_0-1612766662199.png

Manager A dropdown result

hong_yip_1-1612766880007.png

 

Manager B dropdown result

 

hong_yip_2-1612766893002.png

 

Manager C dropdown result

hong_yip_3-1612766903046.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

Best Regards,
Qi

View solution in original post

5 REPLIES 5
hong_yip
Helper II
Helper II

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

Best Regards,
Qi

View solution in original post

Thx 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

Best 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?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,844)