Hello all,
I have a table in excel with events that gets updated. I previously ran a flow to get these events onto a calendar in outlook, then I ran another flow to get the outlook events unique ID, so I could add that to my table and make my existing events, but I wanted to create a flow that does this process in one flow as I was backfilling the uniqueid beforehand. I wanted to run this scheduled flow to grab the rows in my table, check if EventID is empty, if true create a new event in outlook then update the row with the unique id from the previous step, false then update events if there were changes. It was working updating my existing events, but the unique ID wasn't populating correctly for new events.
My flow
Then the condition:
empty(items('Apply_to_each')?['EventID']) is equal to true
Create Event parameters
Update a row parameters
The error:
{
"statusCode": 400,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "e1d76bc8-bce7-4de9-aaad-e6f4c4c426aa",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Thu, 16 May 2024 14:48:20 GMT",
"Content-Length": "354",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 400,
"message": "Required parameter: 'idColumn' missing for requested operation: 'PatchItem'.\r\nclientRequestId: e1d76bc8-bce7-4de9-aaad-e6f4c4c426aa",
"error": {
"message": "Required parameter: 'idColumn' missing for requested operation: 'PatchItem'."
},
"source": "excelonline-cus.azconn-cus-001.p.azurewebsites.net"
}
Please help me with my flow so that when there is a new event created in outlook the unique id gets populated in the excel table with no duplications. Thanks
Share
Report
12
All responses (
Answers (
