https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/125652.aspxMon, 15 Sep 2025 04:29:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125652TOE_CHEESE0https://www.infopathdev.com:443/forums/thread/125652.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125652Thank you. I'll take a look and see if we can get it working.https://www.infopathdev.com:443/forums/thread/125651.aspxFri, 12 Sep 2025 15:35:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125651Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125651.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125651Sample script in this zip. PnP PowerShell recently changed how authentication works and if it hasn't been done yet, you'll need to create an application registration - more info here: https://pnp.github.io/powershell/articles/authentication.htmlhttps://www.infopathdev.com:443/forums/thread/125650.aspxFri, 12 Sep 2025 00:39:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125650TOE_CHEESE0https://www.infopathdev.com:443/forums/thread/125650.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125650Hi Hilary, Thank you. That's a great idea. We didn't think of that. Our initial try with PowerShell is throwing errors. We probably have our code wrong. Do you have an example you can share?https://www.infopathdev.com:443/forums/thread/125649.aspxThu, 11 Sep 2025 22:26:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125649Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125649.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125649Hi - have you thought about using PowerShell for this? Do you use SharePoint Online? I'm guessing yes since you mention Power Platform.... You could use PnP PowerShell to write directly to your list instead of exporting / importing. Just a thought..... PowerShell can manipulate XML pretty easily. And it may be easier for dealing with multiple files than Excel Power Query.https://www.infopathdev.com:443/forums/thread/125648.aspxThu, 11 Sep 2025 22:10:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125648TOE_CHEESE0https://www.infopathdev.com:443/forums/thread/125648.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125648Hi, we are winding it down with InfoPath. Microsoft has given my organization until the end of the year to redevelop everything InfoPath into the Power Platform. I am down to my last form which contains several repeating tables. I need a solution to extract the repeating table data from the xml forms so it can be exported and then imported into a SharePoint list. I have seen options to create a workflow in SharePoint Designer and another to use Excel Power Query. Anyone have any links they can share to walk me thru the process? Thank you,