Create/Update SharePoint List item with data from table captured with Ai Builder

[Glade82]

I have used AI builder to process completed audit checklists.

I have a sharepoint list with a number of columns. 

I am going to store the score for each element of the audit in the list and run KPIs etc

I can use "Create Item" to create an item in the list and populate columns with data captured in fields.

However I can't figure out how to populate columns on the sharepoint list with data from a table captured with AI Builder.

I have tried "apply to each" using conditions to check if the row of the table matches a certain name, then update the item and add the value from the table to the column.

This works for 7 iterations, then the "yes" box for the condition won't allow me to add any further actions.

Can anyone offer guidance of how to get data from the table into a list column.

[antoinec]

Hi Glade82, This documentation section should help: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#iterate-a-document-process... . You should only need to iterate over the table entries once. Let us know if you got it working or need further assistance.

[Glade82 · Accepted solution]

What has been successful was to :

• initialise a variable of type array
• append the table entries to the array

• Then, in "Create Item" you can call the items from the array to populate the columns:

variables('ScorecardArray')[0]

variables('ScorecardArray')[1]

etc...