How to upload large Excel data into SharePoint List using power automate | In Hindi | Part 1

Thanks for watching, you can use the below playlist related to SharePoint
------------------------------------------------
Sharepoint Tutorials from scratch
ruclips.net/user/pl....
----------------------------------------------------
Power Automate Playlist in Hindi
• MS Power Automate Tuto...
You can follow me here
_____________
Instagram
@technicalknowldgebeta
Facebook page
/ technicalkno. .

[@Zee-ot3pw]

bhai aap mic acha wala use karo, like moano au4 plus

[@Abdurrazzaq02]

How to add 1.5 lac records in SharePoint list from Excel?????

[@hamnamh7818]

Hi, i am having an excel file which is having 84k+ records, while using the 'List row present in table' it is failing. and getting an error 'BadRequest. The action 'List_rows_present_in_a_table' has an aggregated page results size of more than '210429765' bytes. This exceeded the maximum size '209715200' bytes allowed.' any idea of any alternate soln to avoid this?

[@TechnicalKnowledgeBeta]

Possible reason would be one of the single line column has max characters
Check that..
Try bulk upload for 10-40 rows fist and then proceed with large data

[@hamnamh7818]

@@TechnicalKnowledgeBeta upto 70k was working fine, when more data was added this error happened. there are chances even more data will be added in the excel so not sure how to resolve this. one alternate solution what i found was to process the two columns that will be used on the next step in PA, but since the column header is having space(Transaction Number) select query is not accepting

[@TechnicalKnowledgeBeta]

Hmm interesting 🤨

[@sparshraikar4333]

Hi how did you make the flow for 84k records ? List rows pagination limit is 5000 , did you use do until loop ? Kindly give some idea thanks