cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cgriese0310
Frequent Visitor

Update Table in a Managed Solution with Power shell

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
cgriese0310
Frequent Visitor

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. 

View solution in original post

7 REPLIES 7
ChrisPiasecki
Super User
Super User

Hi @cgriese0310,

 

Could you clarify a few details.

  1. What kind of updates are you trying to make to the Project Table using PowerShell? Is it schema updates, or data?
  2. 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.

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! 

@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

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.

@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?  

@ChrisPiasecki   This is the error :

Is missing prvCreatefs001_Project_Reference privilege

Thoughts on how to fix this? 

cgriese0310
Frequent Visitor

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. 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,840)