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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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