Update a row issue

Like (0) Share

Report

Posted on 25 Apr 2024 08:55:23 by Martijn2

I am working on a flow that populates data from a Microsoft forms into an excel file with macros.

Basically, with some workarounds, I have now managed to execute update a row in the excel file with macro's. Only the following issue occured. Normally, of course, update a row recognises which columns are in the table and you can specify per column what you want to put in the found row. But given the workaround, it does not recognise the cell beforehand. Because of this, I cannot specify what value I want in the cell and it updates the cell with the same data. Is there another way to still get it to recognise the cell and you can insert a value here?

The file where field 201 must be filled

With hidden coloms

Output:

"body": {

"1": "Requested by",

"2": "201",

"3": "Date",

"4": "901",

"@odata.context": DELETED

"@odata.etag": "",

"ItemInternalId": "201"

Thanks in advance

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

Martijn2 77 on 25 Apr 2024 at 09:19:10

Like (0)

Report

Re: Update a row issue

Found the solution. In the provide the item properties, you have to enter the column name instead of value in the JSON.