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.


Report
All responses (
Answers (