Share
Report
9I have a flow that is to get data from a Hubspot API and add it to an excel file, if the row is already there it adds it to the file. Everything is working to add the rows but updating rows isn't working. Here is a screenshot:
I know the "get a row" and "update a row" are successfully running otherwise I'd have duplicate rows in my data which I don't. It just that data isn't changing in my data even when changed in Hubspot.
Here is the code for the update a row:
{
"inputs": {
"host": {
"connectionName": "shared_excelonlinebusiness",
"operationId": "PatchItem",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"
},
"parameters": {
"source": "sites/analyticscomputerscom.sharepoint.com,2141d990-e5b6-483b-b610-24318b99731c,59da2d26-81d0-4e3f-9f5e-468b89bc70ad",
"drive": "b!kNlBIbblO0i2ECQxi5lzHCYt2lnQgT9On15Gi4m8cK2sEmd-j5waR4UkI1TIVsJZ",
"file": "01QMO4ZLFGCBIOWOLC7VD2UMPWAPAD4RJB",
"table": "{3C89D932-0A94-450D-8C09-9A19C72622BA}",
"idColumn": "hs_object_id",
"id": "@items('Apply_to_each_update')?['id']",
"item/dealname": "@items('Apply_to_each_update')?['properties']?['dealname']",
"item/dealstage": "@items('Apply_to_each_update')?['properties']?['dealstage']",
"item/createdate": "@items('Apply_to_each_update')?['properties']?['createdate']",
"item/hs_lastmodifieddate": "@items('Apply_to_each_update')?['properties']?['hs_lastmodifieddate']",
"item/closedate": "@items('Apply_to_each_update')?['properties']?['closedate']",
"item/pipeline": "@items('Apply_to_each_update')?['properties']?['pipeline']",
"item/amount": "@items('Apply_to_each_update')?['properties']?['amount']",
"item/createdAt": "@items('Apply_to_each_update')?['properties']?['createdAt']",
"item/updatedAt": "@items('Apply_to_each_update')?['properties']?['updatedAt']",
"item/archived": "@items('Apply_to_each_update')?['properties']?['archived']"
},
"authentication": "@parameters('$authentication')"
},
"metadata": {
"01QMO4ZLFGCBIOWOLC7VD2UMPWAPAD4RJB": "/General/Sales Dashboard/DataLake.xlsx"
}
}
and a screenshot of the update a row:
Can anyone spot what I've done wrong?
Categories:
I have the same question (0)
All responses (
Answers (
