Hello there !
I'm quite new using Solutions and Environment variables and I am a bit stuck in a simple process :
What is my problem :
When trying to get the rows of an excel file, using Environment Variables, I get an error and cannot select the right excel file nor the concerned table. I get this error :
which reads "The dynamic invocation request failed with error : { "error": {"code" : "invalidRequest","message":"The provided drive id appears to be malformed, or does not represent a valid drive", "innerError":{/*followed by a bunch of different ID and tokens.*/}}}
And I am trying to find what can work, but i am quite stuck on it.
What I created :
I created a solution called NextFactory_Solution.
In it, I set 3 Environment variables :
- FormID : a string, which will contain the ID of a MS Forms. Default value = the ID of a form I already set for dev purposes
- SiteURL : a database, type Site, with default value a SharePoint site from my environment, let's call it TeamSite
- LibraryID : a database, with the type List, dependant on the SiteURL variable. Default value : the standard Document Library on the SharePoint site.
Here is the settings of LibraryID :
- FilePath : a string environment variable, containing the path+filename of the excel file. In this case it is set to default value "/Client/00.Factory/MyExcelFile.xlsx"
I then added an existing flow to the solution, by clicking "Add existing > automation > cloud flow > Not in dataverse".
To sum up, this flow is triggered when a new response is submitted to a form and it goes fetch the rows of a table set in a excel file stored under the Document library of my SharePoint TeamSite.
When the flow was added to the solution, it was easy to put the FormID environment variable in the trigger, I got no error message.
I then added the SiteURL environment variable to the Excel action, and it worked well, because Power Automate found the right document libraries by itself into the Document Library field.
The issue is when i add the variable LibraryID, Power Automate do not show me all the folder to browse under the File field.
The error I talked to you about is appearing.
Now, I created the FilePath variable, but the error remains, it is just triggered by the Table field :
This error is slightly different but from the same rootcause I think. It says :
Could not retrieve values. The dynamic invocation request failed with error: {
"status": 400,
"message": "Invalid request\r\nclientRequestId: 504da1d4-b657-4ce3-94b4-5451f5b3bffe\r\nserviceRequestId: 0cb5dc87-f3fd-4a39-9399-caf5d07fdb40",
"error": {
"message": "Invalid request"
},
"source": "excelonline-ncus.azconn-ncus.p.azurewebsites.net"
}.
Could you please help me to understand what i did wrong when initializing my Environment Variables ?
Thanks a lot !
Have a wonderful day
