Power Platform Community Forum Thread Details

Environment Variable - Not recognizing for Document Library of Excel Get Tables

Hi Everyone!

I have a flow in Power Automate and I set a couple of environment variables. One of those (called "Arquivo_Carga") is pointing to a document library called "Carga_Dados":

In my flow, I use this enviroment variable "Arquivo_Carga" on this step to Get all the files from that library

It works fine!

However, a couple next steps, I have one to Get the tables I have inside those Excel files, so if I set the Document Library manualy to "Carga_Dados" it works fine! However, if I place my environment variable "Arquivo_Carga" it does not work, it gets "bad request" when I run

With manually set "Carga_Dados":

With variable point to "Carga_Dados":

Look what have in Document Library of Get Tables when I place manually "Carga_Dados":

Now, look what have when I place a environment variable "Arquivo_Carga" and get error:

Get Files step accept this 864ae2..etc but Get Tables step does not! Both are Library (well, one is Library Name and other Document Library, but both are the same stuff).

Here is the environment variable set: