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
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.
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.
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?