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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / JSON Validator using P...
Power Apps
Unanswered

JSON Validator using Power Automate and Excel

(1) ShareShare
ReportReport
Posted on by 4
Originally I have posted my question here - https://answers.microsoft.com/en-us/msoffice/forum/msoffice_other-msoffice_unknown-mso_unsupported/offline-json-schema-validator-tool-in/a1bd7ee5-7381-4436-8218-fe856f74c4d7?messageId=def23238-5706-4a17-ab01-39138d5886bc

The problem is I have JSON files extracted from database and I want to perform validation against defined JSON schema like this online tool. I searched but couldn't find any tool but I got a very good suggestion from Jonathan to use Power Automate, Office script and excel. I would really appreciate if someone could help me to achieve it. Even if I could a sample script and excel having just few lines would be a lot. I would then replace my json and json schema for validation at appropriate places. Thank you in advance.
Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard