Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Problem using Excel feature - create excel table

(0) ShareShare
ReportReport
Posted on by 20

Hey, 

 

I had a daily working flow that uses excel create table feature, last week that flow continuously failed on that connector.

 

I have not made any changes recently in that flow and still im getting error message - bad request with the body attached:

 

{
"status": 400,
"message": "The expression \"drives('b!OWWXXXXXXXXhXXXwHTcrRZch_Iw0ugzK')/items/b!OWW8QXXXXCELFZBwDZ1XXXXXLJKqq4Pvqh6XXXXX2EFE7RFLV5MA6XDXA7FL\" is not valid.\r\nclientRequestId: XXXXXX",
"source": "excelonline-we.azconn-we.p.azurewebsites.net"
}

 

image.pngimage.png

please advise.

 

thanks, Eli.

  • SOULOUMIAC Profile Picture
    8 on at
    Re: Problem using Excel feature - create excel table

    Hi,

     

    Same issue : how can we set dynamic file in create table excel business ?

     

     

    Regards

    Emmanuel

  • elizi Profile Picture
    20 on at
    Re: Problem using Excel feature - create excel table

    Thanks for your response.

     

    In my flow i can't pick a value from a drop down list because the value doesn't exists before the flow starts.

     

    I use dynamic content from previous steps in my flow to enter a value in the "field" value in "create table" action, so i can't longer use the previous method for filling my dynamic values.

     

    if you familiar with other work around - i will gladly happy to hear.

     

    thanks, 

  • v-bacao-msft Profile Picture
    on at
    Re: Problem using Excel feature - create excel table

    Hi @elizi ,

     

    Recently MS Flow has updated some features.

    The configuration of Document Library including OneDrive is not the same as before.

     

    You could try to reconfigure Create table action. It is recommended to select the option in the drop-down list instead of manually entering the Custom value when configuring Document Library field.

    Please take a try.

     

    Best Regards,

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,537 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,908 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow