Hey can I process all the json data to excel table without using apply to each because apply to each can only process 5000 records and its slow sometimes to process all the records, so is there anyway that i can pass all the records without using apply to each ?
hi, mate. thanks so much for this video! as a beginner, i still find a little difficult to write the express like "item()..." and confuse with the format.... so it seems if we paste the schema in 'parse json', we can directly use phone, itemname, city.. is that correct?
I implemented the same, but in my scenario the data is coming from PowerBI and then compose and after that "appendvariable" and ParseJson and "Apply to each", same steps as you mentiioned, but getting error: error while exporting to excel: InvalidTemplate: Unable to process template language expressions in action 'Add_a_row_int_a_table' inputs at line '0' and column '0'. and template language expression cannot be evaluated because of 'name' cannot be selected. Property selection is not supported on values of type 'String'.
Earlier uploaded a video on similar use case: Simplify JSON Data Import to SharePoint list with Power Automate th-cam.com/video/d8DtIM0RmAE/w-d-xo.html
Ajay, You can use the "Excel - Get Rows" action to retrieve the rows of data from the spreadsheet, and then use the "Response" action to convert the data to JSON. You can also use the "HTTP" action to trigger the Power Automate flow using an API call.
amazing content...looked all over the internet for this!
Thank you.. glad it was useful!😊
Thank you. Great video.
Thank you for the feedback:)
Hey can I process all the json data to excel table without using apply to each because apply to each can only process 5000 records and its slow sometimes to process all the records, so is there anyway that i can pass all the records without using apply to each ?
Excellent video brother!
thank you so much, you are life saver
Glad it was a useful!🤝
hi, mate. thanks so much for this video! as a beginner, i still find a little difficult to write the express like "item()..." and confuse with the format.... so it seems if we paste the schema in 'parse json', we can directly use phone, itemname, city.. is that correct?
Yes
I implemented the same, but in my scenario the data is coming from PowerBI and then compose and after that "appendvariable" and ParseJson and "Apply to each", same steps as you mentiioned, but getting error:
error while exporting to excel:
InvalidTemplate: Unable to process template language expressions in action 'Add_a_row_int_a_table' inputs at line '0' and column '0'. and template language expression cannot be evaluated because of 'name' cannot be selected. Property selection is not supported on values of type 'String'.
Please share screenshots programmingcorporate@gmail.com
Can you help me in parsing the HTTP response in JSON format into excel workbook file
Earlier uploaded a video on similar use case: Simplify JSON Data Import to SharePoint list with Power Automate
th-cam.com/video/d8DtIM0RmAE/w-d-xo.html
How to write flow steps for scheduled email reminder notification on due date filter out from excel data in a SharePoint
Thank you
Glad it was useful and thank you for the feedback!
Please make video to import json data into SharePoint list .🥲plz
Video has been uploaded for the same!
Import JSON Data to a sharepoint list using power automate flow
th-cam.com/video/d8DtIM0RmAE/w-d-xo.html
How would this change if the source array were to be replaced by "List Rows Present in a Table"
Please connect for custom requirements: programmingcorporate@gmail.com
how can i get excel data as json by calling power automate through api?
Ajay, You can use the "Excel - Get Rows" action to retrieve the rows of data from the spreadsheet, and then use the "Response" action to convert the data to JSON. You can also use the "HTTP" action to trigger the Power Automate flow using an API call.
@@corporateprogramming can you please make a video or notes for same?
Thank you
Thank you for the feedback!