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

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

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

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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (37,718)