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 / Parsing JSON data for ...
Power Automate
Unanswered

Parsing JSON data for int and float

(1) ShareShare
ReportReport
Posted on by 74

All,

 

I'm querying Business Central and one of the fields that I'm querying is listed as type integer. However, it often is not a whole number, and has decimal points, as it is currency. When trying to run a Power Automate flow to gather that data, it often errors out because when it tries to pull the data during a loop, it says "Expected Integer instead got Number" --- is there a work around for this?

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @smw356239 

     

    Change your Parse JSON Schema integer to number.

    See below.

     

    "Amount": {
                "type""number"
     }

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard