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 / Power Automate is not ...
Power Automate
Answered

Power Automate is not fetching the dynamic content of the sharepoint

(0) ShareShare
ReportReport
Posted on by 2
Dear Team,
 
I was creating a flow with respect to any item created or modified in the sharepoint should trigger an email/teams notification.
 
But I'm facing an issue as pasted below, "The response from API sharepointonline operation GetTable with status code 200 does not contain a valid OpenAPI schema object.
 
Can you please guide what is going wrong here, is it access issue or does the power automate has limitations on Sharepoint site?
or I'm creating an incorrect workflow kindly suggest a workflow for my idea.
 
Thank you for the support in advance
Categories:
I have the same question (0)
  • Suggested answer
    Fredrik_A Profile Picture
    3,644 Super User 2026 Season 1 on at
    Hello,
     
    Try making a new SharePoint connection and see if that fixes it
     
    If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.
  • Verified answer
    DP_Prabh Profile Picture
    381 on at

    Cause:
    The Get lists action is causing the error. It’s unnecessary and sometimes fails to read the SharePoint schema.

    Fix:

    • Delete Get lists action.
    • Re-add the SharePoint trigger with:
      • Site Address
      • List Name


    If issue persists:
    -  Refresh SharePoint connection
    - Re-add the connector
    - Ensure you have access to the SharePoint list.
           - Correct Site Address
           - Correct List Name
           - Valid SharePoint connection

    Suggestion: 
    Remove the get list action if you are getting same list from SharePoint. The trigger already provides the item details; Get lists is not required.

    I hope this works for you!

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard