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

Community site session details

Session Id : 0O6Ew4HUMRNI4Qjh5DMtvw
Power Automate - Building Flows
Unanswered

Add a row into a table - problem

Like (0) ShareShare
ReportReport
Posted on 5 Feb 2024 15:42:19 by 18

I've created a Power Automate flow triggered from Power Apps that exports a SharePoint list to Excel. When I initiate the flow, everything works as expected. However, when other users trigger the flow, I encounter an error at the "Add a row into a table" action.

 

5ar94T_0-1707147520536.png

 

{
  "status": 400,
  "message": "Invalid request\r\nclientRequestId: 3651c94c-98dc-4dda-bb92-2aa9f3722011\r\nserviceRequestId: 8db94575-8ecb-490d-bb45-aff3345a40ff",
  "error": {
    "message": "Invalid request"
  },
  "source": "excelonline-ne.azconn-ne-002.p.azurewebsites.net"
}
 

Users have appropriate access rights. I've tried recreating the action and replacing the connection, but the result is the same.

 

Does anyone have an idea what the issue might be?

 

 
 
 
  • 5ar94T Profile Picture
    18 on 07 Feb 2024 at 11:43:39
    Re: Add a row into a table - problem

    I have recreated the flow, now it works for users from my company, but not for guest users. Guest users have the same access rights to SharePoint as users from my company.

  • Lynch66 Profile Picture
    84 on 06 Feb 2024 at 12:28:52
    Re: Add a row into a table - problem

    You need square brackets at the start and end of the Compose 2 action as well as the curly brackets [{}]

  • 5ar94T Profile Picture
    18 on 06 Feb 2024 at 08:31:27
    Re: Add a row into a table - problem

    5ar94T_0-1707207870187.png

    5ar94T_1-1707208030083.png

    5ar94T_2-1707208111858.png

    5ar94T_4-1707208180879.png

     

     

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 2 on 05 Feb 2024 at 16:00:28
    Re: Add a row into a table - problem

    Hi @5ar94T 

     

    Could you please share the screenshot(s) of the flow in edit mode? 

     

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete