cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Trying to Filter multiple items in Sharepoint using Filename

Hi,

 

I've been trying to build a Powerapp that allows users to paste item name data from excel and pull up a gallery view of thumbnail images matching the item name. I'm running into an issue trying to filter the data input as multiple entries. I know i should use the  Split function to separate text input by spaces

Split(TextInput1.Text," ")

 but i'm stumped on where to go from here. I thought to store the strings in a collection and make my gallery something like:
Filter(sharepointList1, foreach(Collection1.Result = Name)) or
foreach(collection1.result, Filter(sharepointList1, result=name) ? sorry i'm not familiar with the syntax at all yet.
chrome_2020-10-23_14-24-29.png
Any help would be appreciated, Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver II
Resolver II

@JohnnyPP

 

Split should return an array. So you could filter your sharepoint list using in

 

Try

Set(myArray, Split(....)) 

Filter(SharePoint List, name in myArray)

 

Send from my mobile so can't really test it. 

 

 

View solution in original post

3 REPLIES 3
Resolver II
Resolver II

@JohnnyPP

 

Split should return an array. So you could filter your sharepoint list using in

 

Try

Set(myArray, Split(....)) 

Filter(SharePoint List, name in myArray)

 

Send from my mobile so can't really test it. 

 

 

View solution in original post

Brilliant, thanks so much! Works like a charm and even clears after the button is pressed. Now i'll get to work on making the thumbnails work. Thanks again,
Johnny

@JohnnyPP

 

Good to hear.

 

Please mark as solved... 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,655)