Skip to main content

Notifications

Create an Excel using Microsoft Flow - SharePoint

Implementation Steps:

 

1. Navigate to Your SharePoint Site.

 

2. Click Documents or Open Your Document Library

rampprakash_0-1661411292934.png

 

3. Click New and Select Excel Work Book

 

rampprakash_1-1661411322752.png

 

4. Once Selected it will Open a Page in Different Window

 

5. Create a Column and Frame a Table (Optional)

 

rampprakash_2-1661411385278.png

 

 

6. Once Done Rename the Excel File (Optional). Here i renamed it as Parent Document.xlsx

rampprakash_3-1661411618542.png

 

7.  Now Navigate to https://make.powerautomate.com

 

8. Click My Flows --> Select Instant Cloud Flows --> Provide Name for the flow --> and Select PowerApps

 

rampprakash_4-1661411792929.png

 

9. Once Click on Create it will open a Page

 

10. Now Select Add Step and Search for SharePoint 

 

rampprakash_0-1661411865785.png

 

 

11. Once Selected It will Create a Connection --> Then Select GET FILE CONTENT USING PATH

 

rampprakash_1-1661411930637.png

 

12. Once Selected input the Site URL and Path of our Excel File

 

rampprakash_2-1661411972795.png

 

 

13. Once Done --> Click Save and Test --> Automatically --> Run Flow

 

14. Once it is Success you will get File Content

 

rampprakash_3-1661412032910.png

 

15. Now Click on Add Steps --> Search for Compose --> And Paste the Content from GET FILE CONTENET USING PATH

 

rampprakash_4-1661412107103.png

 

16. Once Done --> Create a New File with the Same File Content 

 

17. Click Add New Step --> Select Create File --> Input Site Address, Folder Path(where to create a new file), File name and Content from Compose

 

rampprakash_5-1661412139936.png

 

18. Once Done Click Test and Run the Flow

 

rampprakash_6-1661412227799.png

 

19. if the Flow Ran Successfully, Navigate to SharePoint to View the New File

 

rampprakash_7-1661412259457.png

 

20. Now here you can see the New File Copied Successfully --> Open the File to Check the Columns

 

rampprakash_8-1661412320537.png

 

 

That's it 🙂 This is How we need to Create an Excel using Microsoft Flows with SharePoint

 

Video For your Reference : https://youtu.be/z-86xSgghTI

 

Comments

*This post is locked for comments