Unanswered

Creating Date Column using Power Automate

(1) Share

Report

Posted on by 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.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (2)

Report

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 !

Was this reply helpful? Yes No
RTbmart 20 on at

Like (1)

Report

Was this reply helpful? Yes No
RTbmart 20 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (2)

Report

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 !

Was this reply helpful? Yes No
RTbmart 20 on at

Like (1)

Report

@Nived_Nambiar

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

Was this reply helpful? Yes No
tmsn 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
JS-22071843-0 2 on at

Like (1)

Report

The images explaining the filling out the CSV are broken. Could we get an update that explains that step @Nived_Nambiar?

Was this reply helpful? Yes No