Fixing Multi-Row Lookup for Table Write Actions in Excel

·

I have a column which is a multi row lookup. After that I have a column which is a write to table action. Somehow the write to table action is only writing the first element to the new table but not looping through all the results of the look up column.

1 comment

Channeled
APP
·
·
When using a multi-row lookup column with write to table, you need to properly configure the list mapping functionality to process all results instead of just the first element. To make write to table loop through all lookup results: 1. In your write to table configuration, make sure you select the multi-row lookup column in the "Select the column with lists" step. 2. During setup, ensure you're using "Use Case #1: List Mapping" rather than "Use Case #2: Column mapping" since you're working with multiple items. 3. When mapping the data, select the specific list properties you want to transfer to your destination table columns. If you're still having issues, try these troubleshooting steps: 1. Delete the affected column 2. Create a fresh column 3. Re-map your data to the write to table This should ensure all items from your multi-row lookup are properly processed.
Sources: Write to Other Table | Documentation | Clay University Write to Table [Clay 101] - Clay University