Power Platform Community Forum Thread Details

"Invalid/missing argument or invalid format" when trying to update an excel row with "=HYPERLINK("...";"...")" formula

Hi everybody! I need help with the following issue. I built a flow that creates two dynamic variables ("Outputs" and "Date") and should update a row in an excel table creating an hyperlink to the URL (which is the variable "Outputs") hidden behind "Date". The flow is working perfectly fine on one excel file but the same exact flow does not work when used to update a second excel file (probably the two files have different properties, but I do not know where to start looking for this discrepancy).

The flow works fine on one excel file updating the rows in the column I (as shown below):

But the following error pops up when trying to apply the same flow to a second (almost identical) excel file:

{

"status": 400,

"message": "The argument is invalid or missing or has an incorrect format.\r\nclientRequestId: 3e3111e8-b80f-436d-9d77-845e18b13855\r\nserviceRequestId: 7fe97579-2781-46fa-aad2-7e2440d7c4bc",

"error": {

"message": "The argument is invalid or missing or has an incorrect format."

"source": "excelonline-cus.azconn-cus.p.azurewebsites.net"

}

I am temporarily circumventing the problem by removing the "=" from the formula "=HYPERLINK("Outputs";"Date") so that the string of text (no formula, therefore no hyperlink) is updated to the desired cell, and by manually adding the "=" in front of the formula to convert it into an hyperlink directly in the excel file but this is quite annoying.

Any idea about how to fix the problem would be extremely appreciated.

Thanks 🙂

Quick Links

Leaderboard