locked
How to export InfoPath repeating table content from SharePoint form library to Excel using Power Query RRS feed

  • Question

  • Hello,

    Is it possible to export the content of an InfoPath repeating table from SharePoint form library to Excel using Power Query?

    Thanks & regards,

    Friday, November 18, 2016 9:38 AM

Answers

All replies

  • Why don't you just try to connect to it from Power Query and see what happens. Power Query looks for tabular data. It will depend on how the browser renders the form as to whether it works or not.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Saturday, November 19, 2016 3:43 AM
  • As a default Power Query will only show the first row of the repeating table. This seems to be a well known issue discussed in older posts. However I'm curious to know whether it has been resolved or whether a solution exists with some additional coding.
    Sunday, November 20, 2016 5:51 PM
  • Hi ExponentialGrowth. I'm not familiar with this issue. Can you provide some additional details about what you're seeing?

    Thanks,

    Ehren

    Wednesday, November 23, 2016 6:57 PM
  • The forum seems to indicate that "body text cannot contain images or links until we are able to verify your account". How can I get my account verified to provide you screenshots?

    Essentially I connect to a SharePoint Form Library using Power Query. I wish to export all the line items in a repeating table found within the InfoPath form(s) uploaded to this SharePoint Library Form.

    Unfortunately I can only view the first line items in the repeating table through Power Query.

    The below tutorial seems to indicate there may be a way to bypass this problem using the Advanced Editor function of Power Query. However I can’t seem to get it to work. Please advise.

    http://thebaretta.blogspot.com/2015/06/reporting-power-query-sharepoint.html

    Thanks & regards,

    Thursday, November 24, 2016 11:33 AM
  • Hi there. What issues are you running into with the solution detailed in the blog post?

    Ehren

    Monday, November 28, 2016 9:05 PM
  • Hello Ehren,

    The tutorial was written for SharePoint 2010. I'm using SharePoint 2016. However I can't seem to match step 1. The default code I get when connecting to the list is as follows:

    let
        Source = SharePoint.Tables("https://sites.abb.com/sites/MVD-PTT/lodz/", [ApiVersion = 15]),
        #"8da83292-6ae4-421e-96ec-235a763c09e8" = Source{[Id="8da83292-6ae4-421e-96ec-235a763c09e8"]}[Items]
    in
        #"8da83292-6ae4-421e-96ec-235a763c09e8"

    I have tried replacing "Tables" with "Contents" and "Items" by "Content" but I get the following error message:

    Expression.Error: The key didn't match any rows in the table.
    Details:
        Key=Record
        Table=Table

    Why does the code default to "[Items]" instead of "[Content]"? Do I really need to rename the source or can I just connect via its ID?

    Thanks & regards,


    Tuesday, November 29, 2016 12:20 PM
  • What happens if you try this?

    let
        Source = SharePoint.Contents("https://sites.abb.com/sites/MVD-PTT/lodz/")
    in
        Source

    Using this code, do you see a link to the item you're looking for? If so, try clicking the link and see if you get the full results.

    Ehren

    Tuesday, November 29, 2016 7:18 PM
  • Thanks Ehren! Your suggestion got me through steps 1 & 2. I will work on step 3 today and revert back with results.

    Wednesday, November 30, 2016 9:07 AM
  • Hi ExponentialGrowth,

    Did you make any more progress with this?


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Thursday, December 22, 2016 10:01 AM