How to parse complex JSON in power automate
In this video we use a complex JSON file and parse it using power automate flow. In the end we convert extracted JSON elements into a CSV file and store it to SharePoint online.
Link to the JSON content:
http://dotnetking.com/files/Xero_dummy_invoices_extract.txt
- 0:00 Introduction and problem definition
- 1:30 Analyzing the JSON content
- 1:59 Developing the Power Automate Flow
- 5:55 Extracting the array from the JSON file
- 7:57 Converting JSON schema to match the csv fields
- 11:20 Converting JSON to csv
- 17:35 Saving the csv extract to SharePoint library
- 19:10 Conclusion
To enroll in my Udemy courses see below link for discount vouchers
https://sslwsh008.securedata.net/dotnetking.com/UdemyCourses
Contact me
- LinkedIn https://www.linkedin.com/in/alirezaaliabadi/
- Twitter https://twitter.com/aaliabadi1
- Instagram https://www.instagram.com/alireza.aliabadi_ig/
- Facebook https://www.facebook.com/alireza.aliabadi.fb/
Видео How to parse complex JSON in power automate канала Alireza Aliabadi
Link to the JSON content:
http://dotnetking.com/files/Xero_dummy_invoices_extract.txt
- 0:00 Introduction and problem definition
- 1:30 Analyzing the JSON content
- 1:59 Developing the Power Automate Flow
- 5:55 Extracting the array from the JSON file
- 7:57 Converting JSON schema to match the csv fields
- 11:20 Converting JSON to csv
- 17:35 Saving the csv extract to SharePoint library
- 19:10 Conclusion
To enroll in my Udemy courses see below link for discount vouchers
https://sslwsh008.securedata.net/dotnetking.com/UdemyCourses
Contact me
- LinkedIn https://www.linkedin.com/in/alirezaaliabadi/
- Twitter https://twitter.com/aaliabadi1
- Instagram https://www.instagram.com/alireza.aliabadi_ig/
- Facebook https://www.facebook.com/alireza.aliabadi.fb/
Видео How to parse complex JSON in power automate канала Alireza Aliabadi
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Using Parse JSON to process complex objects in Power Automate to ExcelLearn JSON in 10 MinutesHow to read and create JSON objects in Power AutomateFiltering Microsoft Power Automate “Get Items” with Filter QueryHow to retrieve Value from Complex JSON Object and Array in Power Automate using Expression?Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new featuresBefore you upload your first course on udemy, watch this!How to create web API using Microsoft FlowHow to create an HTML table using Power Automate (Flow) in mailPowerApps - Send Collection to Flow using JSON Function (Tutorial)Everything you need to build Power Automate Approval workflow - 2/2Power Automate Tutorial - SharePoint HTTP Connector Part 1- GETFlow String Manipulation, Replace, Contains, and moreCopy files from one SharePoint library to other with content types and metadata using Power AutomateHow to Parse JSON Data using Excel and PowerQueryUsing APIs With Microsoft Flow & PowerAppsHow to send multiple list items in ONE email using Microsoft FlowHow to create a table in Power Automate Approval request - MarkdownPower Automate – Extracting Values from JSON ArrayHow to get data from JSON objects using expressions in Power Automate