Hi r/MicrosoftFlow!,

​

I'm currently trying to construct a flow that does the following:

- For a specific Excel File

1. Get all tables in the file that are named tblJob*
2. For each table, get each row
3. For each row, if the value of the "Status" column is "Let", and the "Date Let" column is empty, populate the "Date Let" column with the current date.

​

To get to this, I have built a flow that does the following:

1. Manual Trigger (for testing)
2. Get tables
3. Filter array down to tables that start with "tblJob"
4. Convert time zone (to get a correctly formatted and timezoned date)
5. Initialize Variable named "TradeName" (used later for column key)
6. Apply to Each on filtered array of tables
   1. List all rows in table
   2. Filter array down to rows with "Status" is equal to "Let"
   3. Filter array down to rows with "Date Let" is equal to ""
   4. Apply to Each on filtered array of rows
      1. Set Variable "TradeName" to "item()?['Trade']"
      2. Update row in table, using table name from 6., using Key Column "Trade" and Key Value "TradeName" Variable.

Here is a screenshot of my flow: https://imgur.com/IA6jflw

​

The problem:

Because I am using a run-time expression for the table name, I am not given the option to add a value to the "Date Let" column.

Any idea how I can make this work?  Is there a different approach I should try?