Unanswered

Dataverse Trigger: Using environment variable for table name

(0) Share

Report

Posted on by tajoynes

I'm trying to create a flow that could be re-used in different environments by having the table name set as environment variable that is updated when the flow solution is imported into a new environment. However, power automate throws an error saying that it cannot find the table. I'm using the entity set name as the environment variable for the specific table. Screenshot 2024-06-06 at 5.53.08 PM.png Screenshot 2024-06-06 at 5.52.00 PM.png

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @tajoynes ,

I think you should use entity logic name rather than entity set name here.

Best Regards,

Wearsky

Was this reply helpful? Yes No
tajoynes 4 on at

Like (0)

Report

I've tried that but other dataverse actions fail because it cannot find the table with the 'logical name'. They only work with the entity set name

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @tajoynes ,

I saved the entity logic name in environment variables and applied that variable to the trigger, it saved successfully.

Can you show the steps that fail?

Best Regards,

Wearsky

Was this reply helpful? Yes No
tajoynes 4 on at

Like (0)

Report

Hi, I used the the logic name in the trigger and the set name for dataverse actions later throughout the flow, it saved and ran without errors

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @tajoynes ,

Yes, the names used in the trigger and the action are different. Glad to see you solved the problem.

Best Regards,

Wearsky

Was this reply helpful? Yes No