How to parse json in power automate flow

preview_player
Показать описание
Parse or iterate json in power automate

This video is to demonstarte, how easly we can extract data from a complex JSON object/array. super easy solution with minimal use of apply_to_each action.

Best use of data operation like compose, select, filter array, join, send email v2, get items, remove duplicate and how to combine multiple arrays with unique values.
Filter sharepoint list like excel

Easy Solution to filter JSON object/Array
Best way to filter Sharepoint list
Combine multiple Arrays with Unique values
Extract data based on spcific value from datasourse
Extract Look-up Field values/text.

[Update: max item count for ‘get items’ action is 5000.]
To fetch more than 50,000 records from a SharePoint list refer to the channel uploaded a video on it.

#powerautomate #FilterJSONLikeExcel #json #sharepoint
Рекомендации по теме
Комментарии
Автор

Hi
Thanks for sharing.
I am Patching the data in the form of JSON format from Power Apps to Sharepoint more than 20 records per day

[{"Date":"2023-02-03", "Employee_ID":"A01", "Employee_Name":"Name 1", "Meal_For":"Snacks", "Meal_Type":"OT", "Remarks":"1", "Shift":"A"},
{"Date":"2023-02-03", "Employee_ID":"A02", "Employee_Name":"Name 2", "Meal_For":"Dinner", "Meal_Type":"Paid", "Remarks":"2", "Shift":"B"},
{"Date":"2023-02-03", "Employee_ID":"A03", "Employee_Name":"Name 3", "Meal_For":"Dinner", "Meal_Type":"OT", "Remarks":"3", "Shift":"C"}]

I need to filter the data Date wise, Meal_Type & Totals etc
Request you help me to achieve my requirement.

bujjibabukj