Unanswered

Can't pass number input from adaptive card to Excel add a row into a table/无法将自适应卡片提交的数据更新进excel中

(0) Share

Report

Posted on by JY-Seox

I want to build an adaptive card to collect colleagues' time data monthly. But it failed that number data can't input to excel.Anyone could help to fix it. Do appriciate!!!Below are the details

我想要创建一个自适应卡片每月收集我同事的工时数据，目前卡在最后一笔提交数据并将数据添加到Excel中，有没有人能帮忙看看，十分感谢！

以下是细节

cloud flow in power automate/我在power automate中创建的云端流

adaptive card :

{
"type": "AdaptiveCard",
"$schema": "https://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.4",
"body": [
{
"type": "TextBlock",
"size": "Large",
"weight": "Bolder",
"text": "📋 本月数据收集",
"wrap": true
},
{
"type": "TextBlock",
"text": "请填写以下四项数据，填写后点击【提交】。",
"wrap": true,
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "workhour",
"label": "1. 当月预计工作小时数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "pdrhours",
"label": "2. 本月 PDR 小时数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "vacationdays",
"label": "3. 本月预计休假数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "overtimehours",
"label": "4. 本月预计加班时长",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
}
],
"actions": [
{
"type": "Action.Submit",
"title": "✅提交",
"style": "positive",
"associatedInputs": "none"
}
]
}

Excel result: You could see that only 2 number data input successfully and column C to F have no data /Excel结果，只有提交人和提交时间成功回传了，另外四个数据失败了
Compose results : as I'm not professional IT person, and AI advise me to use this step to analyze submitted data/我不是专业IT人士，根据AI建议创建了compose步骤去分析数据
Add employee data input:

{
    "host": {
        "connectionReferenceName": "shared_excelonlinebusiness",
        "operationId": "AddRowV2"
    },
    "parameters": {
        "source": "me",
        "drive": "b!8kNl7idrkkKVLmTJ4PrFC2r0HYj2zAJNmeXlRfroAPm9FWvdnVFVRJB8XmB5DcH9",
        "file": "01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW",
        "table": "{2613D076-6C7E-4297-A6E7-6CB2FE50F909}",
        "item/提交时间": "2026-05-08T09:22:42.822118Z",
        "item/提交人": "JY",
        "item/当月预计工作小时数": null,
        "item/本月PDR小时数": null,
        "item/本月预计休假数": null,
        "item/本月预计加班时长": null
    }
}
 
Add employee data output
{
    "statusCode": 200,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Set-Cookie": "ARRAffinity=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;Secure;Domain=excelonline-ea.azconn-ea-001.p.azurewebsites.net,ARRAffinitySameSite=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;SameSite=None;Secure;Domain=excelonline-ea.azconn-ea-001.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "ecbcfa26-51f7-4b16-847e-067666d47eae;bb5aee33-d776-4d70-adc6-f8358b640371;f546478d-d67f-4b0f-8c63-f98b64144081;f4cbec86-706b-4fa0-9021-32ae1d3ba30c;8ba49bee-a1e1-41c4-9fe6-9985a6b0bace;279f4952-5e27-4e36-b90e-845b986086ca",
        "OData-Version": "4.0",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-environment-id": "default-8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",
        "x-ms-tenant-id": "8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",
        "x-ms-subscription-id": "Default-8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",
        "x-ms-dlp-re": "AddRowV2|False",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-creator-id": "6005b4ec-abe5-4ab1-92df-2c80f9054874",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Fri, 08 May 2026 09:22:45 GMT",
        "Content-Type": "application/json; odata.metadata=minimal",
        "Expires": "-1",
        "Content-Length": "671"
    },
    "body": {
        "@odata.context": "https://excelonline-ea.azconn-ea-001.p.azurewebsites.net/$metadata#drives('b%218kNl7idrkkKVLmTJ4PrFC2r0HYj2zAJNmeXlRfroAPm9FWvdnVFVRJB8XmB5DcH9')/Files('01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW')/Tables('%7B2613D076-6C7E-4297-A6E7-6CB2FE50F909%7D')/items/$entity",
        "@odata.etag": "",
        "ItemInternalId": "db2c0753-22f6-4e96-9b0c-32351c925ebb",
        "提交时间": "2026-05-08T09:22:42.822118Z",
        "提交人": "JY"
    }
}

Categories:

Building flows

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Tomac 4,153 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JC-14050949-0

Can you go into a completed flow run and show the output of your Add Employee Data action? That will tell us if data is being passed to Excel for columns C and F (workhours and overtimehours). If correct data is being passed to Excel, then the issue is in the spreadsheet. If incorrect or no data is being passed to Excel, then the issue is in the flow.

Was this reply helpful? Yes No
JY-Seox 4 on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry for late reply and many thanks for your help!!!.

Belows are the detail of a successfully ran flow

Raw output

{

    "statusCode": 200,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Pragma": "no-cache",

        "Transfer-Encoding": "chunked",

        "Vary": "Accept-Encoding",

        "Set-Cookie": "ARRAffinity=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;Secure;Domain=excelonline-ea.azconn-ea-001.p.azurewebsites.net,ARRAffinitySameSite=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;SameSite=None;Secure;Domain=excelonline-ea.azconn-ea-001.p.azurewebsites.net",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "x-ms-request-id": "ecbcfa26-51f7-4b16-847e-067666d47eae;bb5aee33-d776-4d70-adc6-f8358b640371;f546478d-d67f-4b0f-8c63-f98b64144081;f4cbec86-706b-4fa0-9021-32ae1d3ba30c;8ba49bee-a1e1-41c4-9fe6-9985a6b0bace;279f4952-5e27-4e36-b90e-845b986086ca",

        "OData-Version": "4.0",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "x-ms-environment-id": "default-8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",

        "x-ms-tenant-id": "8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",

        "x-ms-subscription-id": "Default-8bf3ea15-8d0e-4c87-bfc6-7c086f2820f7",

        "x-ms-dlp-re": "AddRowV2|False",

        "x-ms-dlp-gu": "-|-",

        "x-ms-dlp-ef": "-|-/-|-|-|-",

        "x-ms-mip-sl": "-|-|-|-",

        "x-ms-au-creator-id": "6005b4ec-abe5-4ab1-92df-2c80f9054874",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Fri, 08 May 2026 09:22:45 GMT",

        "Content-Type": "application/json; odata.metadata=minimal",

        "Expires": "-1",

        "Content-Length": "671"

    },

    "body": {

        "@odata.context": "https://excelonline-ea.azconn-ea-001.p.azurewebsites.net/$metadata#drives('b%218kNl7idrkkKVLmTJ4PrFC2r0HYj2zAJNmeXlRfroAPm9FWvdnVFVRJB8XmB5DcH9')/Files('01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW')/Tables('%7B2613D076-6C7E-4297-A6E7-6CB2FE50F909%7D')/items/$entity",

        "@odata.etag": "",

        "ItemInternalId": "db2c0753-22f6-4e96-9b0c-32351c925ebb",

        "提交时间": "2026-05-08T09:22:42.822118Z",

        "提交人": "JY"

    }

}

input:

{

    "host": {

        "connectionReferenceName": "shared_excelonlinebusiness",

        "operationId": "AddRowV2"

    },

    "parameters": {

        "source": "me",

        "drive": "b!8kNl7idrkkKVLmTJ4PrFC2r0HYj2zAJNmeXlRfroAPm9FWvdnVFVRJB8XmB5DcH9",

        "file": "01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW",

        "table": "{2613D076-6C7E-4297-A6E7-6CB2FE50F909}",

        "item/提交时间": "2026-05-08T09:22:42.822118Z",

        "item/提交人": "JY",

        "item/当月预计工作小时数": null,

        "item/本月PDR小时数": null,

        "item/本月预计休假数": null,

        "item/本月预计加班时长": null

    }

}

Was this reply helpful? Yes No
Tomac 4,153 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JC-14050949-0

Thanks for following up with that data. From this, we can see in the action input that columns C and F are not trying to write any data to Excel:

Please copy/paste the Code View of the Add Employee Data action (in edit mode) so we can see the full value names being referenced.

My guess is you're referencing different values in the Add Employee Data than are being generated in the Postcard action. In this sample:

The two fields that are carrying over to Excel are fixed data pieces (responseTime and responder), but none of the referenced data fields are coming over.

Also, what is that Compose action doing? It doesn't seem to be referenced anywhere.

Was this reply helpful? Yes No
JY-Seox 4 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank Tomac for your reply again🙇‍！

Compose is the action that Copliot advise me to add to analysis why data input to excel failed. So maybe it generate incorrect response. You could ignore this action~!

For 4 failed parameters, I clicked lighting icon and then choose the option in the select box.

Belows are detail.

Code view of add employee data

{

"type": "OpenApiConnection",

"description": "Add a row to Excel with all Teams card response values mapped: workhour, pdrhours, vacationdays, overtimehours.",

"inputs": {

"parameters": {

"source": "me",

"drive": "b!8kNl7idrkkKVLmTJ4PrFC2r0HYj2zAJNmeXlRfroAPm9FWvdnVFVRJB8XmB5DcH9",

"file": "01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW",

"table": "{2613D076-6C7E-4297-A6E7-6CB2FE50F909}",

"item/提交时间": "@outputs('Postcard')?['body/responseTime']",

"item/提交人": "@outputs('Postcard')?['body/responder/email']",

"item/当月预计工作小时数": "@outputs('Postcard')?['body/data/workhour']",

"item/本月PDR小时数": "@outputs('Postcard')?['body/data/pdrhours']",

"item/本月预计休假数": "@outputs('Postcard')?['body/data/vacationdays']",

"item/本月预计加班时长": "@outputs('Postcard')?['body/data/overtimehours']"

},

"host": {

"apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness",

"connection": "shared_excelonlinebusiness",

"operationId": "AddRowV2"

}

},

"runAfter": {

"Compose": [

"Succeeded"

]

},

"trackedProperties": {

"提交时间": ""

},

"metadata": {

"01JAG4K2Y2F6HKKDETFVFYM5LNRH37VWFW": "/JY/AI/power automate/员工数据收集.xlsx",

"tableId": "{2613D076-6C7E-4297-A6E7-6CB2FE50F909}"

}

}

Code of adaptive card

{
"type": "AdaptiveCard",
"$schema": "https://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.4",
"body": [
{
"type": "TextBlock",
"size": "Large",
"weight": "Bolder",
"text": "📋 本月数据收集",
"wrap": true
},
{
"type": "TextBlock",
"text": "请填写以下四项数据，填写后点击【提交】。",
"wrap": true,
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "workhour",
"label": "1. 当月预计工作小时数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "pdrhours",
"label": "2. 本月 PDR 小时数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "vacationdays",
"label": "3. 本月预计休假数",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
},
{
"type": "Input.Number",
"id": "overtimehours",
"label": "4. 本月预计加班时长",
"isRequired": true,
"errorMessage": "此项为必填，请输入数字",
"spacing": "Medium"
}
],
"actions": [
{
"type": "Action.Submit",
"title": "✅提交",
"style": "positive",
"associatedInputs": "none"
}
]
}

Was this reply helpful? Yes No