Unanswered

Dataverse functions

(0) Share

Report

Posted on by Sandeep Gunda

I created a Dataverse function using Power Fx. In this function i am using Collect operation to set the global option set value of a table record. Now i am facing issue while deploying this in to a new environment. solution import is failed with "Name" isnt valid

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Kushal_M 131 on at

Like (0)

Report

Hello Sandeep Gunda,

You are using Collect() inside a Dataverse function. Dataverse functions are server-side and stateless. However Collect(), ClearCollect(), Any operation that modifies a collection is NOT supported in Dataverse Functions.

Instead of Collect(), update the table directly using Patch in the dataverse function.

Patch(
MyTable,
LookUp(MyTable, MyTableId = recordId),
{
Status: 'My Global Choice'.Active
}
)

🏷️ Please tag me @Kushal_M, if you still have any queries related to the solution or issue persists.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

Was this reply helpful? Yes No
Sandeep Gunda 2 on at

Like (0)

Report

Thanks for response for new record Patch function is not supported.

Was this reply helpful? Yes No
Kushal_M 131 on at

Like (0)

Report

Hello Sandeep Gunda,

Thanks for sharing the information !

My view here is " Your Power Fx function is referencing a Global Option Set value by its label or environment-specific name, not by a stable, solution-aware reference. When you deploy to a new environment: Global Option Set labels may differ and Option Set internal names or numeric values may not match. Power Fx validates expressions at import time which results "Name" isn't valid. "

Would it be possible to paste your Collect() formula here and internal option set internal names ?

Was this reply helpful? Yes No