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!

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.

Users online (2,318)