web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create Table (in Excel...
Power Automate
Answered

Create Table (in Excel) no longer working

(0) ShareShare
ReportReport
Posted on by 29

I have a flow that has been deployed in the default environment for ~1 year, working with no problems at all (and is still working now). 

Since creating this flow I have come to understand the need for solutions and environments for proper deployment. As such, I have redeployed the solution into my Developer environment and I am now testing it within the Test environment. 

 

(Amongst other things) The flow takes a blank file from a template folder, creates a new file from that content and then adds a table to it. 

The flow is now failing at the "Create a table" step.

 

Previously, this worked fine:

Jakebrowno_0-1681899260620.png

 

 

When in the UAT phase it failed with "Invalid Request":

Jakebrowno_1-1681899295149.png

 

This the UAT flow for reference (fails in the same way in the Dev environment also):

Jakebrowno_2-1681899346198.png

 

For "File:" I have tried - 

  • ID as it was originally 
  • File Path
  • Item Id
  • Hard coding Library/Folder/ then File Name dynamic content 
  • Hard coding /Folder/ then File Name dynamic content 
  • Getting file properties > using Identifier 

All fail with the same error! Any ideas?

Categories:
I have the same question (0)
  • Verified answer
    Jakebrowno Profile Picture
    29 on at

    Found the answer thanks to @sipsUp  and this thread: Data Source Environment Variables - Connect to Sha... - Power Platform Community (microsoft.com).

     

    Essentially you have to find the Drive ID for the Library in question.

    You do this by using a test flow a "hard coded" (i.e. not environment variables) Excel link to the library and checking the inputs in the run flow.

    Then create a text environment variable with that drive ID. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 469

#3
11manish Profile Picture

11manish 364

Last 30 days Overall leaderboard