How to update cells in a spreadsheet?

[ianwuk]

Hello Everyone.

I have a cloud flow that reads data from a spreadsheet and gets the future time (6 months from now) and stores it as a variable.

From the Future Time variable I then assign it to a variable called FutureMonth and get the month name using the formatDateTime(parseDateTime(split(body('Add_to_time'), '-')[1], 'en-US', 'MM'), 'MMMM', 'en-US').

I get the rows from my spreadsheet using List rows present in a table.

I then use an Apply to each to update three rows in the spreadsheet.

I want to add the value in column R on each row with the value in column Q on each row.

I want to add the value of FutureMonth into column R of each row.

When I run this, it fails at this Apply to Each step and says The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('List_rows_present_in_a_table')' is of type 'Object'. The result must be a valid array.

How can I solve this please?  Thanks!

[annajhaveri · Accepted solution]

@ianwuk  to resolve the error, in apply to each action select value (list of items) from dynamic content of List rows action 

[ianwuk]

Thank you @annajhaveri 

Update - The issue below is fixed.

I have another issue, I have a flow that outputs an Excel table to an HTML table and then sends an email.

The problem is that the Excel column displays the date in the email as a timestamp.

How can I format that to just be DD/MM/YYYY?

Thanks so much!