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 / JSON Schema does not work
Power Automate
Answered

JSON Schema does not work

(0) ShareShare
ReportReport
Posted on by 2

Hi! 

I would like to use the function "JSON Analyse" to get data from a webpage. For this I use the body from a HTTP with a GET method and generated the JSON Schema:

...

                "high": {
                    "type": "number"
                },
                "openinterest": {
                    "type": "number"
...
 
Normally this works fine. But the problem is that if one value (e.g. "high") is empty ("openInterest"204.3"high"""), the whole flow fails with the message "Invalid type. Expected Number but got String.".
If I change the Schema to String the flows works as long as the is no value for "high". But the next time there is a number for "high" the flow fails again with the message 
"Invalid type. Expected String but got Number.".
 
How can I get out of this "error-loop"?
 
Thank you very much!

 

 

Categories:
  • Verified answer
    eric-cheng Profile Picture
    5,171 on at

    Hi @Lef37 ,

     

    Please refer to this blog and issue 4 for a fix on the problen which is to remove type.

     

    ericcheng_0-1632555278054.png

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

     

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 211 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 190

Last 30 days Overall leaderboard