0

I am currently working on an automation to copy a row to an excel table from Smartsheet, then extract that table data to a SharePoint list (thanks Microsoft :( ). However I'm having an issues filtering my automation to the new row that was added or if get it to work the automation gives an error. The flow below (without using the output from the filter array step) works but copies all the rows in the sheet and creates a table, which is not feasible.

enter image description here

Final Step:

enter image description here

If i add the filtered array then i get the following error : A value must be provided for item. clientRequestId xxxxxxxx-xxxxxx-xxxx

How can I have only the current/New row added to my table?

Puno
  • 61
  • 9

1 Answers1

0

I finally figured it out. I shared the updated flows below.

enter image description here enter image description here

Puno
  • 61
  • 9
  • I am trying to achieve much the same thing, would be great if you could share more information as to the expressions used. I'm struggling to get just the last row of the modified smartsheet to add to a excel. I get the whole thing not just the last row – user639410 Jun 29 '22 at 16:54