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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / POWER APPS COLLECTION ...
Power Apps
Unanswered

POWER APPS COLLECTION TO POWER AUTOMATE

(0) ShareShare
ReportReport
Posted on by 195

Hi Everyone, 

Good day ! 

I need help passing a collection in power automate so that I can parse it.  The code used below is . 

ForAll(
 colMarketsImpacted,
 Collect(
 colSMR,
 If(
 IsBlank(
 LookUp(
 Filter(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID,
 Market.Id = colMarketsImpacted[@Country].Id
 ),
 MarketRegion.Id = colMarketsImpacted[@Region].Id
 )
 ),
 If(
 IsBlank(
 LookUp(
 Filter(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID,
 Market.Value = "All"
 ),
 MarketRegion.Id = colMarketsImpacted[@Region].Id
 )
 ),
 If(
 IsBlank(
 LookUp(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID && MarketRegion.Value = "Global"
 )
 ),
 LookUp(
 colServiceRegionMarket,
 Service.Value = "Unknown"
 ),
 LookUp(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID && MarketRegion.Value = "Global"
 )
 ),
 LookUp(
 Filter(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID,
 Market.Value = "All"
 ),
 MarketRegion.Id = colMarketsImpacted[@Region].Id
 )
 ),
 LookUp(
 Filter(
 colServiceRegionMarket,
 Service.Id = PrimaryServiceInput.Selected.ID,
 Market.Id = colMarketsImpacted[@Country].Id
 ),
 MarketRegion.Id = colMarketsImpacted[@Region].Id
 )
 )
 )
);
Set(jsoncolSMR, JSON(colSMR, IncludeBinaryData));
SendEmailtoPPLTest.Run(jsoncolSMR);

 

Power automate result. Only limited with 

YamiteKudasai_0-1652689007612.png

 

result only contains account name photo. But What I want is to get all the field values from the collection. 

How to obtain such result.? Thanks in advance for your help.

 

Categories:
I have the same question (0)
  • Verified answer
    v-liwei-msft Profile Picture
    on at
    Re: POWER APPS COLLECTION TO POWER AUTOMATE

    Hi @YamiteKudasai ,

     

    In PowerApps, the JSON function converts the table to a string type.

    You can insert compose into the flow and use the JSON function to convert the string back into an array .

    I have made a test for your reference:

    vliweimsft_0-1652954193616.png

     

    vliweimsft_1-1652954193621.png
     

    Beat Regards,

    Levi

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard