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 / Missing OData in conte...
Power Automate
Unanswered

Missing OData in content-type (Response Headers)

(0) ShareShare
ReportReport
Posted on by 36

I issue a graph query using the Invoke an HTTP request action to read an Excel file in a SharePoint library. The request URL looks like this:

a.png

I've omitted "drive id" and "drive item id".

This works fine in my dev tenant, but throws an error when I run the same flow in my customers tenant. The error I'm receiving is
"Open navigation properties are not supported on OpenTypes. Property name: 'UsedRange'."

 

So I run the URL in Graph Explorer to see what's happening. When I run against my own evironment, it works fine (as expected) and I get these Response Headers:

b.png

When I run against the customer environment (which generates the error) I get these Response Headers:c.png

Apparently, OData is missing and that's probably why I get the error. How can this be? I've set up the exact same flow in both environments.
I don't know if there are some tenant setting or whatever that might be different and I'm completely at a loss here.

Please give some advice, thanks!

Categories:
I have the same question (0)
  • Javier Gallego Profile Picture
    Microsoft Employee on at

    Hi Papageno, 

     

    It could be a cache issue, did you try to test in other browser?

    I would like recommend you to try change the connections.

     

    I hope it help you.

     

    JAvi

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard