Implement more PowerPlatform commands

[appieschot]

With the advent of hacktober fest and our ambition to create a set of new good first issues following a list of commands we need for the Power Platform, a first 'shot' at it below. Lets gather additional requests in this issue and create new issues based on them.

good first issues

Issues that should be relatively easy since we already have some of the stuff in place

• [ ] m365 pp environment get
• [ ] m365 pp gateway get
• [ ] m365 pp solution list
• [x] m365 pp tenant settings list see #3657
• [ ] m365 pp tenant settings set

The following should be straightforward but I have not looked into the API's for it yet:

• [x] m365 pp solution list see #3668
• [ ] m365 pp solution get
• [ ] m365 pp solution remove
• [ ] m365 pp solution add
• [ ] m365 pp solution edit to set the publisher, version and description
• [ ] m365 pp solution publisher list
• [ ] m365 pp solution publisher get
• [ ] m365 pp solution publisher add
• [ ] m365 pp solution publisher remove

Needs research to execute CRM queries first

• [x] m365 pp dataverse table list see #3653
• [ ] m365 pp dataverse table remove
• [ ] m365 pp dataverse table get
• [ ] m365 pp dataverse table row list
• [ ] m365 pp dataverse table row add
• [ ] m365 pp dataverse table row merge
• [ ] m365 pp dataverse table row remove
• [ ] m365 pp dataverse query -> we need to figure out if we do a generic query and pass the table + query or if we need other advanced scenario's. See https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api

Needs research for what API to use (most likely easy as it is part of the PowerShell)

• [ ] m365 pp tenant settings set

V2 release

• [ ] pp solution export
• [ ] pp solution import

[martinlingstuyl]

What about pp solution export and pp solution import?

[appieschot]

@martinlingstuyl would be a great addition, but already part of the pac cli, so my vote would be to prioritize them last and focus on the stuff that's not there yet.

[martinlingstuyl]

That's fine with me!

[martinlingstuyl]

Adding them to the epic would still be good though

[appieschot]

Done :D

[ryanspain]

I'd love to see commands like the below to improve the inner dev loop when working on web resources. This would save having to use other [still great] tools like spkl from Scott Durow and XrmToolBox plugins.

• pp dataverse webresource list
• pp dataverse webresource get
• pp dataverse webresource export
• pp dataverse webresource import

Each with options to provide a --solution and --environment amongst other options.

Unsure whether it would be better placed under pa webresource list, given web resources are generally used in model-driven Power Apps. Or possible via pa solution webresource [list/get/export/import] given that pa solution uses a solution project in the current directory.

Thoughts? I'd love to contribute to the design/dev if you think there would be interest.

[appieschot]

@ryanspain that totally makes sense, feels like we should put them under our dataverse command as from what I know a web resource is stored in the dataverse database and thus feels 'correct' to group under there.

We would love to have them specced. I have added them to the epic and feel free to spec out!.

[appieschot]

Note to self: https://learn.microsoft.com/en-us/power-automate/web-api we can use this to retrieve flows as well :)

[appieschot]

@nicodecleyre since you already did some awesome work with #4174 would you mind giving speccing the get and remove versions a stab as well? Looks like our full list is almost complete so would be awesome!

[nicodecleyre]

@nicodecleyre since you already did some awesome work with #4174 would you mind giving speccing the get and remove versions a stab as well? Looks like our full list is almost complete so would be awesome!

Done!

• [ ] #4325
• [ ] #4326

[milanholemans]

@nicodecleyre since you already did some awesome work with #4174 would you mind giving speccing the get and remove versions a stab as well? Looks like our full list is almost complete so would be awesome!

Done!

* [ ]  [New command: `m365 pp aibuildermodel get` #4325](https://github.com/pnp/cli-microsoft365/issues/4325)

* [ ]  [New command: `m365 pp aibuildermodel remove` #4326](https://github.com/pnp/cli-microsoft365/issues/4326)

Included them in the specs of this epic