UKC

I'm going to really test the limit of UKC knowledge.

Youtube, Google and Enterprise ChatGPT have let me down on this.

I can't find any examples to use for how to update a table in an excel document using the power automate connection when the filename for the excel document is dynamic (ie the connector cannot access this specific file during the development of the power automate process and read the table details). If I build it with a specific file and swap for dynamic something is not matching up because tables aren't the same between identical files.

The excel file is created by the power automate. It copies a template, puts it in a new directory (driven by new item on a microsoft list). I have a work around where I use "add a row", which is fine for simple table. But eventually I need to push and pull info from the microsoft list and I really want Update a row to work.

ChatGPT gave up, and google just gets me youtube videos where the excel file is explicitly stated. I just need a better starting point for how to do this.

Maybe try on the Automation Discord Server. I find that can be a wealth of Knowledge of Power Automate.

https://discord.gg/pMhNeyhG

From what you've described, I'm pretty sure this covers it? or at least covers how to make the reference dynamic using an example file with the correct formatting and should be adaptable.

youtube.com/watch?v=caPFTd8CCdk&

Thanks. I watched the start of that video where she uses a static file and never noticed that later she would change it. Also I think the indexing of the video says Add a row, but actually she is using Update. When I'm off the train I can look closer to get how she gets the table reference.