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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,376)