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

Filtering using Listbox

Hi, I am trying to filter a Gallery using a ListBox but not succeeding.

 

The Listbox has a 3 options specified in Items:

["Yes","No","TBC"]

 

The expression i am using for the Gallery is:

Filter('Enquiries List',Approved_x0020_by_x0020_Ax in ListBox1.SelectedItems.Value)

 

Approved_x0020_by_x0020_Ax is a column in my Sharepoint List (Enquiries List) which is of the Type "Choice" where the options are: Yes, No, TBC.

 

I can't see what i'm doing wrong, so any help is appreciated.

 

Thanks.

 

 

12 REPLIES 12

@Mike8,

Hi Mike,

I have created a swagger and i was able to createa custom connection to powerapps.

but I'm unable to get values from that connection into a dropdown om powerapps.

 

Thanks,

MK

Mike8
Memorable Member
Memorable Member

Hello MK1,

Does the connector send data? If you use postman for example using your swagger file can you see the data?

If yes, in powerapps you need to have them in a table.
You can try to
ClearCollect(CollectionName,TitleOfTheAPI.OperationIdOfTheAPI(ParametersOfTheAPI)) and check if you have data in the collection.
If you have data in the collection you need to set the collection as a source,
Dropdown1.Items = CollectionName
 

@Mike8,

I'm  not using a postman collection. I'm Importing a OPen API fle. When i try to get data into table or else into any control i'm unabke to get data .

1.PNG

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,144)