cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
virakones
Resolver II
Resolver II

Adaptive Card: How to repeat Fact Set Element within card from a Parse JSON action with multiple objects?

 

Hello, I'm using more custom adaptive cards but just running into some challenges (new to JSON).

 

Background:

 

Recently put together a Powerapp for Teams where a user will submit pricing details to a Lead to approve or edit.

Upon submission, the details will trigger a power automate flow that sends a custom Adaptive Card with text input fields that will look up a record and edit values if an edit is made. Otherwise there is a button to simply approve.

 

Issue:

I have a Parse JSON action that will serialize the request details into an array of objects. Then, I use an 'Apply to Each' action using the body of the Parse JSON action to fill in the Adaptive Card details. However, the Card itself will send multiple times for each object rather than simply repeating the Fact Set element in the card itself, so its just 1 card. Not multiple.

 

Question:

In my template JSON below, how do I bind the Parse JSON output properly to the "$data" property of the Fact Set that I want to repeat below?

 

Tried following the official documentation but just having no luck connecting it to the Parse JSON action.

 

Here is a look at the flow:

Capture.PNG

 

Here is a look at the Card

Capture2.PNG

 

Here is the Adaptive Card Template payload

- In the Fact Set $data property, I would like to bind the Parse JSON data

{
    "type": "AdaptiveCard",
    "body": [
        {
            "type": "Container",
            "style": "emphasis",
            "items": [
                {
                    "type": "ColumnSet",
                    "columns": [
                        {
                            "type": "Column",
                            "items": [
                                {
                                    "type": "TextBlock",
                                    "size": "Large",
                                    "weight": "Bolder",
                                    "text": "@{variables('varClientName')}"
                                }
                            ],
                            "width": "stretch"
                        }
                    ]
                }
            ],
            "bleed": true
        },
        {
            "type": "Container",
            "items": [
                {
                    "type": "ColumnSet",
                    "columns": [
                        {
                            "type": "Column",
                            "items": [
                                {
                                    "type": "TextBlock",
                                    "size": "ExtraLarge",
                                    "text": "@{variables('varOrderDescription')}",
                                    "wrap": true
                                }
                            ],
                            "width": "stretch"
                        }
                    ]
                },
                {
                    "type": "FactSet",
                    "facts": [
                        {
                            "title": "Submitted By",
                            "value": "@{variables('varSubmittedBy')}"
                        },
                        {
                            "title": "Confirm Date",
                            "value": "@{variables('varConfirmationDate')}"
                        },
                        {
                            "title": "In-Hands Date",
                            "value": "@{variables('varInHandsDate')}"
                        },
                        {
                            "title": "Client Budget",
                            "value": "@{variables('varClientBudget')}"
                        },
                        {
                            "title": "Client Price",
                            "value": "@{variables('varClientTargetPrice')}"
                        }
                    ],
                    "separator": true,
                    "height": "stretch"
                },
                {
                    "type": "ColumnSet",
                    "columns": [
                        {
                            "type": "Column",
                            "width": "stretch",
                            "items": [
                                {
                                    "type": "FactSet",
                                    "facts": [
                                        {
                                            "title": "SKU",
                                            "value": "{$root.sku}"
                                        },
                                        {
                                            "title": "Description",
                                            "value": "{$root.description}"
                                        },
                                        {
                                            "title": "Unit Price",
                                            "value": "{$root.unitPrice}"
                                        },
                                        {
                                            "title": "Quantity",
                                            "value": "{$root.quantity}"
                                        },
                                        {
                                            "title": "Production Type",
                                            "value": "{$root.productionType}"
                                        }
                                    ],
                                    "$data": "{$root}" // Bind the Parse JSON data here
                                }
                            ]
                        },
                        {
                            "type": "Column",
                            "width": "stretch",
                            "items": [
                                {
                                    "type": "Input.Text",
                                    "placeholder": "Edit Unit Price",
                                    "maxLength": 1000,
                                    "id": "acEditPrice"
                                }
                            ],
                            "id": "@{items('Apply_to_each')['id']}"
                        }
                    ]
                }
            ]
        },
        {
            "type": "Container",
            "style": "emphasis",
            "items": [
                {
                    "type": "ColumnSet",
                    "columns": [
                        {
                            "type": "Column",
                            "items": [
                                {
                                    "type": "TextBlock",
                                    "horizontalAlignment": "Right",
                                    "text": "Total Price Submitted",
                                    "wrap": true
                                }
                            ],
                            "width": "stretch"
                        },
                        {
                            "type": "Column",
                            "items": [
                                {
                                    "type": "TextBlock",
                                    "weight": "Bolder",
                                    "text": "@{variables('varProductsTotalSum')}"
                                }
                            ],
                            "width": "auto"
                        }
                    ]
                }
            ],
            "bleed": true
        },
        {
            "type": "Container",
            "items": [
                {
                    "type": "ActionSet",
                    "actions": [
                        {
                            "type": "Action.Submit",
                            "title": "Submit",
                            "style": "positive",
                            "data": {
                                "id": "{$root.id}",
                                "action": "approve"
                            }
                        }
                    ]
                }
            ]
        }
    ],
    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
    "version": "1.2",
    "fallbackText": "This card requires Adaptive Cards v1.2 support to be rendered properly."
}

 

0 REPLIES 0

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (4,857)