cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Updating all rows in all tables in Excel Online

Hi All!,

 

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

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

6.1. List all rows in table

6.2. Filter array down to rows with "Status" is equal to "Let"

6.3. Filter array down to rows with "Date Let" is equal to ""

6.4. Apply to Each on filtered array of rows

6.4.1. Set Variable "TradeName" to "item()?['Trade']"

6.4.2. Update row in table, using table name from 6., using Key Column "Trade" and Key Value "TradeName" Variable.

 

The problem:

Because I am using a runtime 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?

 

Trade Letting Flow.png

2 REPLIES 2
Community Support
Community Support

Hi @BrendanErofeev,

 

Unfortunately, it is not supported to set table or file names dynamically in Microsoft Power Automate, there is an IDEA about it, you can head to vote it, collect votes to make it come true in the future:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Dynamic-excel-table-names/idi-p/267002

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @v-litu-msft ,

 

Thanks for the info.  I'll add my voice to the previous suggestion.

 

While I understand this might not be possible using the approach I have taken, what other ways could I achieve the outcome I want?

 

Based on what I've seen, the way it is working behind the scenes is by using a PATCH request.  Could I craft my own patch request so I don't have to rely on the intelligence built into Automate?

 

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (48,180)