Power Platform Community Forum Thread Details

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

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:

General Questions