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

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
Vish WR Profile Picture

Vish WR 376

#2
Valantis Profile Picture

Valantis 361

#3
David_MA Profile Picture

David_MA 294 Super User 2026 Season 1

Last 30 days Overall leaderboard