cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Australia
Post Patron
Post Patron

Search a SharePoint "Choice" column in Power Apps?

Hi fellow Power Apps veterans,

 

I am new to Power Apps and currently am trying to search a choice value.

I have the following function:

 

Sort(
Search('My SharePoint List',
Search.Text,        --this is an Input Text
"StaffName",      -- A column in my SP list, single line of text
"StaffNumber",  -- A column in my SP list, single line of text

"Choice"             -- A column in my SP list, choice

),
'Date of Submission',  -- A column in my SP list, date
Descending
)

 

Where "Choice" is a choice in my SharePoint list. 

 

I tried both "Choice".selected.value and "Choice".value but no luck.

 

Hope someone would be able to shed some light on how I could get the syntax to work.

Thank you.

17 REPLIES 17

Hi Hardit,

 

Sorry I meant "This Form isn't connected to any data yet." was just a warning message not an error and was only showing in the Editor Mode. Not sure if this is an expected warning and is normal?

I confirm the Data Source of the Form = LookUp('My SharePoint List',ID=Gallery.Selected.ID)

I also confirm that I can see details of records in each datacard in the Form in both Editor and Play mode. 🙂

 

Thanks mate.

That should be fine. I have seen that happen, just cannot recollect when and in which case. Anyways, let me know if there are any other issues. 

 

Thanks,

Hardit Bhatia

Hey Hardit,

Just wanted to let you know that it's all working fine now.

I found where I got it wrong, the "Lookup" syntax should be in 'Item' not 'Datasource' of the Form. 

That was it. 🙂

 

Thanks again and have a great weekend.

Thank you! This worked for me.

Hi,

I have a form created from a SharePoint List and I would like one of the Choice columns in the form to be searchable when someone enters text. Does your lines of code work for this scenario and where would I enter it (e.g. OnSelect, defaultselecteditems, etc)?

 

Thank you!

Hi,

 

need help with app that has choice field from vlookup.

problem is to setup SEARCH by every word in choice field (NAME)

 

Anyone can help me.

Hello! Can you also please help write the code for:

1. Data Table instead of Gallery

2. More choice fields than "Choice" e.g. a second choice column called "Choice 2" and a third called "Choice 3"

3. Also include a Rich Text field/multiple lines of text field called "Multiple Lines"

 

Thank you!

Bless you sir, this helped me, I can keep my job. LOL

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

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 Solution Authors
Top Kudoed Authors
Users online (2,715)