web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Array using Con...
Power Apps
Unanswered

Filter Array using Contains

(0) ShareShare
ReportReport
Posted on by 30

Hi,

 

I have a requirement which I'm struggling with.

 

Requirement:

Master list of account numbers (there will be thousands).

Filter a document library to see if the account number in the master list is contained within the folder name.

Once returned, delete the folder(s).

 

Current setup

Get file properties (using a filter query which only returns the folders - this works).

Get items (from the master list).

Append all the account numbers into a compose variable (so it's, 123456;22222; etc - this works).

Select function using the output from the get items - the key column here is called "Name". However, the account number from the master list will say "12345"; however, in the document library it will say "12345 FirstName LastName"; therefore, I need to split and only get anything before the space - this is the point which errors / doesn't work.

Filter array using the output from the Select function which says: @contains(@{outputs('Compose_-_account_number')},@{item()['Name']}) - compose_-_account_number is the concatenated values from the master list.

 

This works if compose_-_account_number shows in the correct string: i.e. 12345;252525;23456; however, I need to do the split earlier first.

 

Can anyone advice? Alternatively, is there a better way to solve my requirement?

 

Thanks,

Jamie

 

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard