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 Apps / Struggling to Parse JS...
Power Apps
Answered

Struggling to Parse JSON in PowerApps

(0) ShareShare
ReportReport
Posted on by 901

My apologize, did my research but really struggling, this is my first project working with JSON. Wanted  to know how to get PowerApps to produce the JSON.

 

I have already built a workflow with the parse JSON that I need to populate into a PDF form. Just need to understand now how to get PowerApps to produce the JSON so it could interact with Power Automate.

 

{
	"Provider NameRow1": "",
	"National Provider Identifier NPIRow1": "",
	"Date of Service MMDDYYYY One date per rosterRow1": "",
	"Medicare IDRow1": "",
	"Date of Birth MMDDYYYYRow1": "",
	"Patient Signature or Signature on fileRow1": "",
	"Last NameRow1": "",
	"First NameRow1": "",
	"MIRow1": "",
	"Sex MFRow1": "",
	"Address No StreetRow1": "",
	"CityRow1": "",
	"StateRow1": "",
	"ZipRow1": "",
	"Medicare IDRow1_2": "",
	"Date of Birth MMDDYYYYRow1_2": "",
	"Patient Signature or Signature on fileRow1_2": "",
	"Last NameRow1_2": "",
	"First NameRow1_2": "",
	"MIRow1_2": "",
	"Sex MFRow1_2": "",
	"Address No StreetRow1_2": "",
	"CityRow1_2": "",
	"StateRow1_2": "",
	"ZipRow1_2": "",
	"Medicare IDRow1_3": "",
	"Date of Birth MMDDYYYYRow1_3": "",
	"Patient Signature or Signature on fileRow1_3": "",
	"Last NameRow1_3": "",
	"First NameRow1_3": "",
	"MIRow1_3": "",
	"Sex MFRow1_3": "",
	"Address No StreetRow1_3": "",
	"CityRow1_3": "",
	"StateRow1_3": "",
	"ZipRow1_3": "",
	"Medicare IDRow1_4": "",
	"Date of Birth MMDDYYYYRow1_4": "",
	"Patient Signature or Signature on fileRow1_4": "",
	"Last NameRow1_4": "",
	"First NameRow1_4": "",
	"MIRow1_4": "",
	"Sex MFRow1_4": "",
	"Address No StreetRow1_4": "",
	"CityRow1_4": "",
	"StateRow1_4": "",
	"ZipRow1_4": "",
	"Medicare IDRow1_5": "",
	"Date of Birth MMDDYYYYRow1_5": "",
	"Patient Signature or Signature on fileRow1_5": "",
	"Last NameRow1_5": "",
	"First NameRow1_5": "",
	"MIRow1_5": "",
	"Sex MFRow1_5": "",
	"Address No StreetRow1_5": "",
	"CityRow1_5": "",
	"StateRow1_5": "",
	"ZipRow1_5": ""
}

 

PowerApps.PNG

 

Will change "Manually trigger a flow" once I figure out Power Apps JSON.Workflow.PNG

 

Any help is really appreciated, Thank you in advance.

Categories:
  • Verified answer
    Pstork1 Profile Picture
    69,661 Most Valuable Professional on at

    Power Apps has a JSON function that you can use.  The JSON function takes two arguments, the first is the data you want to convert to JSON and the second controls the JSON format.  For the data parameter its easiest to use either a variable (for a single record) or a collection (for an array of records).  Short example below.

    Set(JSONdata,{ProviderNameRow1: "test", NPIRow1: "test"});
    flow.run(JSON(JSONdata, JSONFormat.Compact));
  • oappdev Profile Picture
    901 on at

    Thank you @Pstork1 , Apologize for the delayed response. I was able to JSON function to work.

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard