Replace unique csv file every minute on sharepoint

(0) Share

Report

Posted on by mheinst

We want to have one unique CSV file name on sharepoint, replace the file every minute.

Now it's only possible to add another file with adding time every minute.

What actions should be take?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@mheinst add a delay may be ?

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
mheinst 21 on at

Like (0)

Report
Copy link

Link copied!

I'm getting an error.
A file with the name Inventory Downloads/Inventory1106.csv already exists. It was last modified by
Error
Action 'Post_a_message_as_the_Flow_bot_to_a_user' failed

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@mheinst try formatting datetime like this

formatDateTime(utcNow(),'yyyy-MM-dd hh:mm:tt')
OR
formatDateTime(utcNow(),'yyyy-MM-dd hh:mm')

First one will give date and time with hours,mins and seconds
Second one will give date and time with hours,mins

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
mheinst 21 on at

Like (0)

Report
Copy link

Link copied!

Yes I have that right now, that works. But I need to keep the file to be replaced with the same name. Adding time will create many unique files instead of 1.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@mheinst delete the file before you create one

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
mheinst 21 on at

Like (0)

Report
Copy link

Link copied!

OK, how do you set that up? I have tried it.
Every minute the file will be updated, how to delete it before the new one will be created?

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@mheinst use get files action, sort by ID descending which and top 1, it will give you the latest file, then use delete file and then create

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
mheinst 21 on at

Like (0)

Report
Copy link

Link copied!

Could you please send a screendump with the actions?

Was this reply helpful? Yes No