Answered

Using a variable with List rows from selected environment

(0) Share

Report

Posted on by novarse

Hello,

I'm trying to use the List rows from selected environment action. It requires you to set the Environment. I want to be able to deploy a solution containing the desktop flow using this action to different environments so the environment changes so I was wanting to use a variable to store the environment. I tried getting the name from the admin section but get an error:
{
"StatusCode": "400",
"Message": "",
"Body": {
"Message": "Invalid organization URL 'sandboxlearn.crm6.dynamics.com' provided.",

I got this from the https://admin.powerplatform.microsoft.com/environments... page

In Power Automate Desktop:

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,855 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @novarse,

It looks like you forgot the https:// part in your variable value. Try the below in your ENV variable

https://sandboxlearn.crm6.dynamics.com

Below is an example for the accounts table.

Was this reply helpful? Yes No
novarse 31 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your help. This accepted the environment which is great but now I'm stuck because it doesn't recognise the table.

The error message is:
Additional info:
{
"StatusCode": "404",
"Message": "",
"Body": {
"error": {
"code": "0x80060888",
"message": "Resource not found for the segment 'vtac_table1'."
}
},

I used the logical name for the table but I also tried the display name, plural name and schema name with similar results.

Was this reply helpful? Yes No
novarse 31 on at

Like (0)

Report
Copy link

Link copied!

I got it to work. I set the environment and table manually and ran the the flow. Opening the results object displayed the table name it used so I tried again with the environment variable and this table name and it worked. Thanks again!

Was this reply helpful? Yes No
novarse 31 on at

Like (1)

Report
Copy link

Link copied!

I'm trying to check the answer byExpiscornovus but it doesn't update this as the verified answer. only when I click my posts.

Was this reply helpful? Yes No