cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Remove choices from an lookup column inside a form

Hello!

 

I got this lookup column in a combobox inside an form with maybe 350+ choices..

 

Some of these choices has the name in the beginning "Removed".

 

Can I somehow IF the column "Cards" contains "Removed" dont show those. Today in the items property it says: 

Choices([@'Log'].Cards)

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Anonymous 

 

I created SP List and tried below

 

App - Power Apps - Google Chrome 5_5_2021 11_41_01 AM.pngApp - Power Apps - Google Chrome 5_5_2021 11_43_12 AM.png

 

Regards,

Chetan

View solution in original post

5 REPLIES 5
PatilChetan
Resolver I
Resolver I

@Anonymous 

 

Have you tried below code in Items property?

Filter(Choices([@'Log'].Cards), !StartsWith('CardName', "Removed"))

Regards,

Chetan

Anonymous
Not applicable

Hello @PatilChetan and thanks for your response!

 

This wont work for me, in the "!StartsWith('CardName', "Removed"))" part I got the error:

invalid argument (control). A text value was expected instead

and

The StartsWith function has some invalid arguments

@Anonymous 

 

Hope you are putting correct field name on place of 'CardName'.

What is your DataSource for the App?

 

I have used DataSource as Account Table of MS Dataverse

App - Power Apps and 1 more page - [InPrivate] - Microsoft​ Edge 5_5_2021 10_51_35 AM.png

 

Regards,

Chetan

Anonymous
Not applicable

@PatilChetan 

 

Its an lookup column in a sharepoint list, I dont know what to put in the spot you written "Full name".

@Anonymous 

 

I created SP List and tried below

 

App - Power Apps - Google Chrome 5_5_2021 11_41_01 AM.pngApp - Power Apps - Google Chrome 5_5_2021 11_43_12 AM.png

 

Regards,

Chetan

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,566)