You’re offline. This is a read only version of the page.
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 .
Share
ReportForAll(
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.
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:
Beat Regards,
Levi
All responses (
Answers (
