InfoPath Dev

Hi, 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,

Hi - 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.

Hi 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?

Sample 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.html

Thank you. I'll take a look and see if we can get it working.