Answered

Update Table in a Managed Solution with Power shell

(0) Share

Report

Posted on by cgriese0310

CONTEXT:

I developed a canvas app using Dataverse in my development environment. I build several custom tables, including a reference table for project attributes such as project number, tasks, client etc... during development we were using Power Shell to update the table from the ERP System, and everything woks swimmingly!

ISSUE:

I Moved the solution from the Development environment into production as a Managed Solution, now I cannot seem to update the Project Reference table using Power Shell in order to have the project attributes that I need.

Is the table being contained in the Managed Solution a limiting factor?
Is there a work around?

Thank you in advance for any help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Hi @cgriese0310,

Could you clarify a few details.

What kind of updates are you trying to make to the Project Table using PowerShell? Is it schema updates, or data?

Are you trying to make changes directly to the managed solution in production, or unmanaged in development?

You will be limited in what changes you can make to a component within a managed solution, this is by design. All component changes should be made to the unmanaged solution. The exported managed solution should be treated as a build artifact that is deployed as is to downstream environments.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
cgriese0310 32 on at

Like (0)

Report

Chris - Thanks for the response.

Your question - what type of changes am I trying to make with PowerShell in the Managed solution

A: I am simply trying to populate it with data 3x a day - essentially a data feed to the existing Schema to populate Project Attributes from our ERP System. I am not attempting to alter the Schema or any properties of the table/object - just populate it with data from the ERP system.

Does this clarify and help?

Thanks!

Was this reply helpful? Yes No
cgriese0310 32 on at

Like (0)

Report

@ChrisPiasecki forgot to mention, I'm attempting to update the data on the projects table in the managed solution.

But again, just trying to update the data... The application itself won't even be writing to this table, it's just using it as reference

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @cgriese0310,

OK - - so it's just data integration that you're trying to achieve. Can you provide some more detail around the kinds of errors you are experiencing?

Also, is there a particular reason you would like to use PowerShell versus other data integration tools available natively, such as Dataflows, Power Automate, Azure Data Factory, Azure Functions, etc?

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
cgriese0310 32 on at

Like (0)

Report

@ChrisPiasecki - we can't even figure our how to write to the table now that its in a managed solution. I take it from your response it is possible... Can you point me to some documentation?

Was this reply helpful? Yes No
cgriese0310 32 on at

Like (0)

Report

@ChrisPiasecki This is the error :

Is missing prvCreatefs001_Project_Reference privilege

Thoughts on how to fix this?

Was this reply helpful? Yes No
Verified answer

cgriese0310 32 on at

Like (0)

Report

The issue was related to security roles - they were not configured correctly to allow writing to the table. Once we addressed that there was no more issue.

Was this reply helpful? Yes No