cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
288088
Post Partisan
Post Partisan

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

@288088 

 

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

@288088 

 

Have you tried below code in Items property?

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

Regards,

Chetan

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

@288088 

 

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

@PatilChetan 

 

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

@288088 

 

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

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 (2,242)