I’m currently working on a workflow where I need to create a new Excel file for today’s date dynamically. In this new Excel file, I need to generate a report of transaction items present in a Queue.
Here is what I have so far:
I can update the Queue and append data to the Excel file using the Append Range activity.
However, I am struggling with the following:
I want to add custom headers to the new Excel file, where data is getting appended row by row.
I am not using the Read Range activity anywhere because my data comes directly from the Queue.
I need to add the column names dynamically only once for the entire process.
How can I ensure that the headers are created one time, and once they are added, only the other activities should run?