cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tdupton
Helper II
Helper II

Send an array from PA to Flow

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?

1 REPLY 1
v-monli-msft
Community Support
Community Support

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,969)