cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

SharePoint/Flow Date/Time record template

Hi, I am trying to create a flow that will record the date & time of any file in an excel file which is uploaded on sharepoint. Is there any template available which can be used to solve above purpose.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: SharePoint/Flow Date/Time record template

HI @Anonymous 

 

Please see the screenshot below:

 

sps.PNG

Here, whenever a new file is created in the documents library, an email is sent. The "Created" field is the date and time stamp this file was created. 

excela.PNG

Add a row in excel with the data. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

7 REPLIES 7
Dual Super User
Dual Super User

Re: SharePoint/Flow Date/Time record template

The problem with your scenario is that the trigger (when a file is created) is always tied to a specific document library. It would be relatively easy to create this flow for a specific library, but now way to make it work across an entire SharePoint site collection or tenant.  You would need one Flow/connector for each document library.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Anonymous
Not applicable

Re: SharePoint/Flow Date/Time record template

Thanks for your quick reply. You are correct. The trigger will apply on  'Document' library. Do we have any template available. It may be silly question but I am new to flow.


@Pstork1 wrote:

The problem with your scenario is that the trigger (when a file is created) is always tied to a specific document library. It would be relatively easy to create this flow for a specific library, but now way to make it work across an entire SharePoint site collection or tenant.  You would need one Flow/connector for each document library.


 

Dual Super User
Dual Super User

Re: SharePoint/Flow Date/Time record template

HI @Anonymous 

 

Please see the screenshot below:

 

sps.PNG

Here, whenever a new file is created in the documents library, an email is sent. The "Created" field is the date and time stamp this file was created. 

excela.PNG

Add a row in excel with the data. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Anonymous
Not applicable

Re: SharePoint/Flow Date/Time record template

Hi 

I am very close to get the desired output by follwoing the way you mentioned. It is really helpful. Awesome. I am just stuck in terms of date and time not captured in excel file. My flow ran successfully as I followed the exact steps. Please see below screenshots and help me.

 

4.png1.png2.png

Dual Super User
Dual Super User

Re: SharePoint/Flow Date/Time record template

@Anonymous 

 

You mean that the excel sheet was not updated at all? Can you please share the screenshot of the updated excel sheet if the sheet was updated with any values?

Anonymous
Not applicable

Re: SharePoint/Flow Date/Time record template

Hi  

I just realised, it's working. It's awesome. Thanks for all your help. I am happy.

Dual Super User
Dual Super User

Re: SharePoint/Flow Date/Time record template

@Anonymous 

 

Glad that it worked!!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,322)