Create Excel File in SharePoint via Power Automate Cloud Flow

Have you ever needed to create a new Excel File in Power Automate and then populate it with data from another source? Maybe the results of another action, an API endpoint or the contents of another Excel File that has been filtered? I will demonstrate how to create an Excel File in a single action, easier that you probably imagined and populate it with data by creating a table and adding a row.

We will then learn how to create logic to either create a new excel file or update an existing file, based on the requirement of a monthly filename.

00:00 Intro
00:54 Create an Excel File in SharePoint using one action
02:16 A look at Reza's Video
03:29 My YouTube Video Stats
04:40 Conditional Logic for existing file
07:53 Setting up input parameters
08:36 Adding a Table to a File
14:00 Updating an Existing Table

#PowerAutomate #Excel

[DamoBird]

I’ve got a favour to ask! If you enjoy this, please double check that you’ve liked the video and subscribed to the channel! Thats a small way you can help me carry on doing this ❤🙏🏾 really appreciate you!

[taaee]

Damo, your explanations are sufficiently objective and adequately detailed, same as Reza. Congratulations!

[Shmank]

Very nice tutorial. You and Reza are great teachers. Thanks!

[KeyserTheRedBeard]

Impressive video, DamoBird365. Looking forward to seeing your next upload. I smashed that thumbs up button on your content. Keep up the excellent work! Your approach to dynamically creating and updating Excel files in SharePoint using Power Automate is fantastic. Have you considered exploring the integration of AI in this process to enhance data analysis capabilities?

[BubbleSorte]

Great video, congratulations. I have a question: the way it was done, is it possible to add multiple rows at once?

[YauteAdventure]

Not able to add rows into the table via an Apply to Each, it can't detect the table previously created therefore doesn't allow me to put the data in. Error says: Could not retrieve values. Value segment type 'literal' expression '' invalid. Only literal segment types may be used.
Copy Error

[AlexanderMeusel-wj]

Hello, nice Video👍🏼 Can you help me? I created a flow in power automate. Its called "create order". the flow looks like this: A user creates an order in my share point list "create order". He also states his information like company name, address, articles and so on. after that, my flow creates a word document, based on a template word doc. later on, that document is also converted into a PDF.
now to the issue: all the information is placed into the doc via quick entry blocks BUT it doesnt do that with paragraphs separating the info, so it looks like (NAME, ADDRESS, ARTICLES) instead of
COMPANY
ADDRESS
ARTICLES
Is there a function to separate the info with paragraphs or any other solution?