Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Send an array from PA to Flow

(0) ShareShare
ReportReport
Posted on by 57

I have a date field in a Sharepoint list. My list contains timesheets per day.  At the end of the week, I need to send an approval email with a flow that contains all of the weekly timesheets in a single email.  I have the weekending date in a calculated field in the list (used to group list items together) but I figured out Flow can't filter on a calculated field.

 

So...how can I send a collection from PA over the flow.  Do I build an array of Sharepoint ID's in PA and then pass that array of ID's to the flow so I can filter the list?  Is there a better way to pass a filtered list of items to Flow?

Categories:
  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: Send an array from PA to Flow

    Hi @tdupton,

     

    The ID fitlered idea is not supported to achieve so far I think. But you could try to filter the items to a collection first in PowerApps then send the collection to Flow. Although it is not the same but the below blog might help on this scenario. Please take a look at:
    Saving a collection of images from PowerApps to SharePoint using Microsoft Flow

    http://www.techmikael.com/2017/05/saving-collection-of-images-from.html

     

    Regards,

    Mona

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard