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

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 III
Helper III

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,963)