Creating Date Column using Power Automate

[RTbmart]

I currently have a flow set up that creates a file in SharePoint once I receive an email containing an attached .csv file.  The flow works perfectly fine; however, I need to edit it so that it will also create a column containing the current date. How could I accomplish this?

Thank you in advance for the help.

[Nived_Nambiar · Accepted solution]

Hi @RTbmart 

well you can accomplish by re creating the same csv table like below

Input file used 

output file got:

date column is added having current date details.

Flow used

in date, expression used is formatDateTime(utcnow(),'yyyy-MM-dd')

Hope it helps !

Mark it as solution if it resolves your query !

[RTbmart]

Hi Nived,

Thank you for your response. Judging by your output file, this flow appears to be accomplishing what I need it to. However, I still need clarification on the "Create CSV table" step.  What did you put in the functions for "skip(...)" and "split(...)"? In other words, what do the periods indicate inside the parenthesis?

I am still new to Power Automate, so I appreciate your assistance very much.

Thanks again.

[Nived_Nambiar]

Hi @RTbmart 

skip function used at at the top is used to retrive the input data for csv table creation, here it takes the file content of csv file, split by new line and then skip the first element created from splitting by new line since the first element is a header, which we don't want now 

function used is 

skip(split(string(outputs('Get_file_content')?['body']),decodeUriComponent('%0A')),1)

Now coming to columns, since csv have values seperated by commas. so we are taking each value and then taking appropriate index value. like below

Just rewriting same columns from csv again, that's all i am doing here 🙂

Hope it helps !

[RTbmart]

@Nived_Nambiar 

Looks like this is working exactly the way I want it to! Thank you!

[tmsn]

Hi @Nived_Nambiar, Thank you for providing these insights. I'm using this same flow and it's working for me. However, there are some differences in my output.

In my output, I'm receiving double quotes in my values. Would you be able to provide any insight on why this is happening or how I can remove the double quotes? I tried using replace with the split function but haven't been able to come up with anything that works.