Answered

Using environment variables to read an excel table from SharePoint

(0) Share

Report

Posted on by JoseH

I have been trying to create a simple flow that needs emails from an excel table in SharePoint. Also, I am trying to leverage environment variables to make all fields easy to modify if needed. I can get variables to work in the Location, File and Table fields of the Lost rows action from excel, but if I use a variable for the document library, I get the below error. Any suggestions would be greatly appreciated

Categories:

Using connectors

I have the same question (1)

All responses (3)

Answers (1)

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

@JoseH

Hi,

Just to clarify, in the columns there that say Custom Value, What is the value you are putting in?
The words 'Custom Value'?

If you put in Environment variables themselves, it breaks?

Was this reply helpful? Yes No
JoseH 11 on at

Like (0)

Report

It is showing a custom value label because I am using environment variables in all fields, Location: SharePoint site URL, File: File location in site, Table: table name in the excel file. The issue is when I try to add an environment variable for the document library, if I do that, then it breaks. If I select the value that auto-populates from the SharePoint site, and keep variables in the other 3 fields it works fine. But I want to use variables on all 3 fields.

Was this reply helpful? Yes No
Verified answer

JoseH 11 on at

Like (0)

Report

UPDATE! I created a flow to manually get the rows from the table and used the actual values instead of variables. I took the Unique ID from the flow for the document library and used that in a variable and now it works.

Was this reply helpful? Yes No