Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Filter Array not returning results on SharePoint List with Multiple people

(0) ShareShare
ReportReport
Posted on by
Howdy, 
 
I have an issue. We have a SharePoint list that we've been requested to create a flow that will run weekly and pull the open items from this list and email people listed as Owners their Current Open items in an HTML List. I got this to work on a test site with single people as owners but I've been struggling to get it to work on the list that allows for Multiple Owners
 
Here's what I currently have on this test site flow
1. I am manually triggering until I get it working correctly
2. Initialize an Array Variable AllOwners
3. GetItems from the SharePoint List with Filter Status eq 'Open'
4. Apply to Each off the Value of Get Items
    A. Compose with Inputs of Owner from Get Items
    B. Select Outputs from the Compose and Map to GetItems Email 
    C. Condition (I've tried without but it fails) If AllOwners Contains Output of Select If No Append Variable AllOwners with OwnerEmail
 
5. I use Compose to display AllOwners
6. Then I initialized an array variable AllItems with the Value of GetItems as the Value (I had thought I could do an Array Filter off this but I have failed so far)
7. I show AllItems in a compose function to verify all items are there. 
8. I have a compose action that removes the Duplicate entries from AllOwners 
union(variables('AllOwners'),variables('AllOwners'))
9. I initialize a new array variable UniqueOwners with the Output of RemoveDuplicates as the value
10. Compose UniqueOwners to verify duplicates are removed
11. Here's where I am struggling. I've tried multiple things Right now I have an apply to each running off UniqueOwners
    a. FilterArray from Value of Get Items where Owner contains CurrentItem. 
Everything I've tried here has either thrown an error or output only gives me an [] with no data. 
I have also Tried filtering off the AllItems Variable with Owner\email contains CurrentItem 
 
Everything I've tried here has failed so any suggestions would be very helpful
 
Help me Obi Wan Community, You're my only Hope
 
Thanks!
-Daniel 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard