Automate

Hello,

I'm trying to create a form that has several scripts that need to loop and have additional loops inside them.  When pulling the repeating content into the form I get both sections but the upload excel data function only seems to hit the first loop level and can't be toggled on the second.  Is there a way to upload data into the second loop?

Attachment(s)

BP_FINISH_SHIP_TO - Test.Txr   1.43 MB 1 version

Hi Scott,

'Upload Excel Data' functionality is not available for nested tables, neither we can use 'Copy Table Data' rule.

One way to do it is :

• Create a repeating table on the form, upload the data in this table using 'upload excel data' option
• Now using 'Data connection' webservice  of type reference data upload this Data from repeating table to a reference list.
• Next using a query control fetch this data on the form in Nested repeating table as per requirement.

Refer Solution, Reference list and excel file attached on link : https://nowtransfer.de/9a17d23e03fa

• Once you import the solution and the reference data list.
• Deploy the solution.
• Launch the form, On launched form upload the excel data, and press save button -> this will save data in the reference data list.
• Click on fetch button in group4 to fetch the data in the nested table.
• Once the data is fetched, you can click Empty table button to clear the table and click SaveData button to clear the list as well.

NOTE :

If your data to be uploaded in the nested table is static or does not change, you can simply create a reference data list with this data and fetch it using a query control.

Hope this helps.

Regards