Answered

SharePoint/Flow Date/Time record template

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

HI @Anonymous

Please see the screenshot below:

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.

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi yashag2255
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.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Glad that it worked!!

Was this reply helpful? Yes No