Power Platform Community Forum Thread Details

Hello all - we are trying to build a flow that pulls data from a data table from one Excel sheet and inserts it into a new data table on a different Excel file. We have it working to where the flow references the correct original table and inserts data into the correct new table. However we're having trouble pulling and inserting the correct data itself. Our steps look like this:

- 'List rows present in a table' - no trouble here

- 'Select' - and have three possibilities. *From *Map Key *Map Value. Believe the *From should be 'value' referencing the rows listed from previous step. But not sure of the *Map Key / *Map Value

- 'Apply to each' - using dynamic content 'output' from the previous step but not sure how to get the right values into the table on the new Excel. We've tried various dynamic content items, manual inputs, but nothing working.

Can anybody assist? Are you able to follow along? See the screenshot below. Please let us know if you can. Thanks!

Test flow 1.JPG