I am writing a Power Automate flow which, among other things, should concatenate three texts and write them in a Excel sheet. However, the error on the title is appearing.
The code is like this:
Excel Instance: =ExcelInstance2
Value to be written: =Concatenate(Name," - ",ID)
Record mode: On the specified cell
Column: 1
Row: =IDRow
I've tried changing the commas to ";", using "&" and the like, but nothing worked. What could be wrong? The Power Fx is active, in case this is relevant.