web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / HOW TO USE JSON DATA C...
Power Automate
Answered

HOW TO USE JSON DATA COMMING FROM POWERAPPS AND USING IT INTO A FLOW WITH A WORD TEMPLATE

(0) ShareShare
ReportReport
Posted on by Koen Huys 93

I have made an app in power apps, I am extracting the data with

Khuys_0-1682688499395.png

When I go to my flow that I am building (trigger Power Apps(v2)

then I get the below result

Khuys_1-1682688559823.png

How can I now convert the data from column name: "Ct_....,Ct_...... into the flow so that I can integrate the cells in a word template

 
 
 
Categories:
Building flows
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 69,387 Most Valuable Professional on at

    Add a Parse JSON step after the trigger to convert the raw JSON into dynamic content.  Just add the value to the main field and generate the schema using the sample output you listed above.  Then you'll be able to use the individual values in the rest of the flow.

  • Koen Huys Profile Picture
    Koen Huys 93 on at

    I tried it but I get Validations failed. the Schema validation failed

     

    that I have then

    Khuys_0-1682689700505.png

     

    so it falls already on the first column

     

     
  • Chriddle Profile Picture
    Chriddle 8,685 Super User 2026 Season 1 on at

    Seems that your data is a string. Use the expression json(your_data_string) to convert it into an object.

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 69,387 Most Valuable Professional on at

    You'll need to manually edit the Type for that field.  It appears that some values are entered as Integers and some as Whole Numbers.  The Type needs to be changed from 

    "type": "Integer" to 

    "type": ["Integer", 'Number"]

    That will accept a value that is either an integer or a whole 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

News and Announcements

Welcome to the Power Platform Communities

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

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 820

#3
Haque Profile Picture

Haque 505

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans