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. Let's 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, see New command: m365 pp environment get #3710
• m365 pp gateway get see New command: m365 pp gateway get #3728
• m365 pp solution list see New command: m365 pp solution list #3711
• m365 pp tenant settings list see New command: m365 pp tenant settings list #3657

The following are straightforward but require a little bit of research for the exact URL's, with some investigation from our side we can make them as 'good first issue', ordered by amount of work to spec:

• m365 pp solution list see New command: m365 pp solution list #3711
• m365 pp solution get see New command: m365 pp solution get #3722
• m365 pp solution remove see New command: m365 pp solution remove #3723
• m365 pp solution publish see New command: m365 pp solution publish #3805
• m365 pp solution publisher add see New command: pp solution publisher add #3977
• m365 pp solution publisher list see New command: m365 pp solution publisher list #3766
• m365 pp solution publisher get see New command: m365 pp solution publisher get #3949
• m365 pp solution publisher remove see New command: m365 pp solution publisher remove #3950
• m365 pp dataverse table list see New command: m365 pp dataverse table list  #3653
• m365 pp dataverse table get see New command: m365 pp dataverse table get #3726
• m365 pp card list New command: m365 pp card list #3767
• m365 pp card get New command: m365 pp card get #3770
• m365 pp card remove New command: m365 pp card remove #3781
• m365 pp card clone New command: m365 pp card clone #3790
• m365 pp dataverse table remove New command: m365 pp dataverse table remove #4031
• m365 pp dataverse table row list see New command: m365 pp dataverse table row list #3791
• m365 pp dataverse table row remove see New command: m365 pp dataverse table row remove #4030

Random ideas

• m365 pp dataverse table row set
• m365 pp dataverse table row move (to associate with other table?)
• m365 pp dataverse table row merge
• m365 pp dataverse table row add
• m365 pp dataverse table column list
• m365 pp dataverse table column get
• m365 pp dataverse table column remove
• m365 pp chatbot list New command: m365 pp chatbot list #3650
• m365 pp chatbot get New command: m365 pp chatbot get #4107
• m365 pp chatbot remove New command: m365 pp chatbot remove #4106
• m365 pp solution add
• m365 pp solution set to set the publisher, version and description
• m365 pp dataverse table businessrule list
• m365 pp dataverse customconnector list validate if we need customconnector or connector
• m365 pp aibuildermodel list New command: m365 pp aibuildermodel list  #4174
• m365 pp aibuildermodel get New command: m365 pp aibuildermodel get #4325
• m365 pp aibuildermodel remove New command: m365 pp aibuildermodel remove #4326
• m365 pp dataverse connection list
• m365 pp dataverse connection get
• m365 pp dataverse connection remove
• m365 pp dataflow list New command: m365 pp dataflow list #6341
• m365 pp dataflow get New command: m365 pp dataflow get #6344
• m365 pp dataflow remove New command: m365 pp dataflow remove #6352
• m365 pp aibuilder prompt list *review aibuildermodel to aibuilder?

Power Pages

• m365 pp website list New command: m365 pp website list #6256
• m365 pp website get New command: m365 pp website get  #6259
• m365 pp website remove New command: m365 pp website remove  #6257
• m365 pp website webfile list New command: m365 pp website webfile list #6262
• m365 pp website webfile add -> maybe call this import (and export)
• m365 pp website webfile remove New command: m365 pp website webfile remove #6320
• m365 pp website webfile get New command: m365 pp website webfile get #6273
• m365 pp website weblink list New command: m365 pp website weblink list #6269
• m365 pp website weblink add -> maybe call this import (and export)
• m365 pp website weblink remove New command: m365 pp website weblink remove #6328
• m365 pp website weblink get New command: m365 pp website weblink get #6277
• m365 pp website webrole list New command: m365 pp website webrole list #6281
• m365 pp website webrole add
• m365 pp website webrole remove New command: m365 pp website webrole remove #6330
• m365 pp website webrole get New command: m365 pp website webrole get #6284
• m365 pp dataverse webresource list New command: m365 pp website webresource list #6336
• m365 pp dataverse webresource get New command: m365 pp website webresource get #6355
• m365 pp dataverse webresource remove New command: m365 pp website webresource remove  #6368
• m365 pp dataverse webresource export
• m365 pp dataverse webresource import

Pipelines

• m365 pp pipeline list New command: m365 pp pipeline list  #6287
• m365 pp pipeline get New command: m365 pp pipeline get #6317
• m365 pp pipeline remove
• m365 pp pipeline add
• m365 pp pipeline set
• m365 pp pipeline stage list New command: m365 pp pipeline stage list  #6292
• m365 pp pipeline stage get New command: m365 pp pipeline stage get #6361
• m365 pp pipeline stage run list New command: m365 pp pipeline stage run list #6305
• m365 pp pipeline stage run get
• m365 pp pipeline artifact list New command: m365 pp pipeline artifact list #6299
• m365 pp pipeline artifact get

Updates

• m365 pp environment remove
• m365 pp environment add

Needs research to execute more complex Dynamic Queries first

• m365 pp data export (see pac data export)
• m365 pp data import (see pac data import)
• m365 pp connector list (see pac connector list)
• m365 pp connector get (see `pac connector download)
• 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
• m365 pp website webfile preview
• m365 pp website webfile sync

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

• m365 pp tenant settings set New command: pp tenant settings set #4572
• Touch base for pa app consent set New command: Power Apps bypass consent for an app #2420
• pipelines options (list / get / edit/set/ remove)
• Create and manage webfiles: https://learn.microsoft.com/en-us/power-pages/configure/web-files
• CRUD for pages

V2 release

• pp solution export
• pp solution import

V3 release

• Support gov cloud environments, some research available in Update PowerPlatformCommand base class with authentication options #2961

[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!