Write to multiple cells in Excel

(0) Share

Report

Posted on by Community Power Pla...

Hey

I'm still a relative new user, and I'm having issues with the write to Excel function.

The situation is that I'm using the flow to generate an audit trail for an internal KPI. As such I would like the flow to write both the value of the KPI, change since last time, the relevant employee to the audit trail, and a timestamp. The value, change and employee name is all in a seperate spreadsheet, and I figured all was well.

Until I realized I'd forgotten about the timestamp. I figured I could use the get current datetime function, but when I add the resulting variable to the write to excel function, it cease to write to multiple cells and instead dump all the data in one cell, making it less than ideal for reading.

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Write to multiple cells in Excel

Hi @Anonymous,

Could you please share the flow with me?

To update the time stamp, we just need to format the date time and save it to the corresponding field in update a row.