web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : fE66trmvsbG0VbJGCY+Cff
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Jan 2024 17:34:55 by 53

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":

bajiomeke_0-1706548603758.png

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

bajiomeke_1-1706548702812.png

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":

bajiomeke_2-1706548929638.png

With variable point to "Carga_Dados":

bajiomeke_3-1706548963716.png

 

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

bajiomeke_4-1706549316820.png

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

 

bajiomeke_6-1706549379355.png

 

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:

 

bajiomeke_7-1706549525734.png

 

I hope I could explain this well..

Please, help me! 😄

I have the same question (0)
  • bajiomeke Profile Picture
    53 on 29 Jan 2024 at 20:43:14
    Re: Environment Variable - Not recognizing for Document Library of Excel Get Tables

    @Matthy79 you are right. I created a new variable, placing those different characters, and now worked:

    bajiomeke_0-1706560982330.png

     

  • Verified answer
    Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on 29 Jan 2024 at 19:44:41
    Re: Environment Variable - Not recognizing for Document Library of Excel Get Tables

    Hello @bajiomeke 

     

    Different actions need the same things in different ways. Some work with IDs, some with names, some with base64 and so on… I think you will need another variable and store the value the second action wants inside.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started
Loading complete