How i can create a excel sheet from a SharePoint document library template

(1) Share

Report

Posted on by johnjohnPter

1,754 Super User 2024 Season 1

We have this document library inside SharePoint site and it contains an excel sheet template that contain single tab and single table:-

Now how i can create a new Excel sheet based on this template? As the Create File action does not have this options as follow:-

Any advice?

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

trice602 14,777 Super User 2025 Season 2 on at

Like (1)

Report

How i can create a excel sheet from a SharePoint document library template

Hi John,

Right before create file, use Get file content using path. That's going to give you the dynamic content for your create file action. Then you simply name the file in create file action and use the dynamic file content from Get file content using path. Works like magic, no pun intended.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
johnjohnPter 1,754 Super User 2024 Season 1 on at

Like (1)

Report

How i can create a excel sheet from a SharePoint document library template

@trice602

Thanks for the reply, so you mean i get the content of the file using the template path? how i can get the template path.. ? thanks

Was this reply helpful? Yes No
trice602 14,777 Super User 2025 Season 2 on at

Like (1)

Report

How i can create a excel sheet from a SharePoint document library template

Yes, use get file content using path to point to your template. Just navigate to the template.

I am at the gym but will send you an example when I get home. Tom

Was this reply helpful? Yes No
johnjohnPter 1,754 Super User 2024 Season 1 on at

Like (1)

Report

How i can create a excel sheet from a SharePoint document library template

@trice602

now i am not sure how i can get the Url of the template..

enjoy your time at the gym :) no rush

Thanks

Was this reply helpful? Yes No
trice602 14,777 Super User 2025 Season 2 on at

Like (0)

Report

How i can create a excel sheet from a SharePoint document library template

Hi John,

Here's some framework for reference. Here I have a template that I want to copy, aka Create File action. So in the Get file content using path, in the File Path field, click on the folder icon and navigate to the file.

In the Create file action, you select the site, folder path, and then give it a file name (these could also be dynamic content such as variables too). So in this example, I am creating a copy of my template "a_table_tst1.xlsx" from above and the copy is "Templatecopy.xlsx" shown below.

Let me know if that is helpful.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
johnjohnPter 1,754 Super User 2024 Season 1 on at

Like (0)

Report

How i can create a excel sheet from a SharePoint document library template

@trice602
I think you did not get what i am asking for exactly. Now in your case the "a_table_test1.xlsx" is an actual file inside the document library ? or it is a template (which i need to get its url- this is my main question-)?, here is the template i am talking about inside my library:-

Thanks

Was this reply helpful? Yes No
trice602 14,777 Super User 2025 Season 2 on at

Like (0)

Report

How i can create a excel sheet from a SharePoint document library template

Hey there!

I am following up on this post how i can create a excel sheet from a sharepoint document library template in this category building flows from 10/29/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 6 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 14,777 Super User 2025 Season 2 on at

Like (0)

Report

How i can create a excel sheet from a SharePoint document library template

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No