Use Environment Variables with List Rows present in a table

(0) Share

Report

Posted on by RM-30040732-0

545

Can someone help me with an issue I'm having with the List rows present in a table action.

I want to be able to use environment variables for each of the inputs however it won't let me?

My Location is a Group as the excel file is the MS Forms response file.

I get this error when I swap out static values for the variables. What am I doing wrong?

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Graph API request failed. Error code is 'invalidRequest'. Error message is 'The provided drive id appears to be malformed, or does not represent a valid drive.'

EDIT: This the flow with static values which works absolutely fine. When I swap out Location, Document Library, File and Table for environment variables I get the above error.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI @RM-30040732-0

Looking at that I do not see any environment variables.

What does this mean exactly

Can someone help me with an issue I'm having with the List rows present in a table action.

I want to be able to use environment variables for each of the inputs however it won't let me?

There is no reason it cannot let you use environment variables, however you are not showing us a screen / errors with that, you have typed stuff in. Please share what you mean by you cannot use environment variables.

Did you add everything to a solution? Did you publish all customizations and then reload the flow so it can see them?

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
RM-30040732-0 545 on at

Like (0)

Report
Copy link

Link copied!

@Michael E. Gernaey

These are the fields I have swapped out for environment variables. It works with static values populated as per my screenshot. It does not work when I swap those values out for environment variables.

Everything is in a solution.

Was this reply helpful? Yes No
Verified answer

RM-30040732-0 545 on at

Like (0)

Report
Copy link

Link copied!

Found the solution!

I just used the file ID's from the Code View instead of their actual names within the environment variables and it worked no problem

Was this reply helpful? Yes No