{"id":1302,"date":"2024-12-01T11:33:00","date_gmt":"2024-12-01T16:33:00","guid":{"rendered":"https:\/\/automatethemundane.com\/index.php\/2024\/12\/01\/automatic-code-review-of-power-platform-canvas-app-reviews\/"},"modified":"2024-12-01T12:00:30","modified_gmt":"2024-12-01T17:00:30","slug":"automatic-code-review-of-power-platform-canvas-app-reviews","status":"publish","type":"post","link":"https:\/\/automatethemundane.com\/index.php\/2024\/12\/01\/automatic-code-review-of-power-platform-canvas-app-reviews\/","title":{"rendered":"Automatic Code Review of Power Platform Canvas App with Power Platform Pipelines"},"content":{"rendered":"\n

A few weeks ago, I was reading on some strategies to do \u201ccode\u201d reviews for power platform solutions. My goal was to figure how to review a solution that was being pushed via Power Platform Pipelines and give the developer and project lead a scoring for how it performed. This got me reading more into Power Apps Code Review tool created by Power CAT powerapps-tools\/Tools\/Apps\/Microsoft.PowerApps.CodeReview at master \u00b7 microsoft\/powerapps-tools \u00b7 GitHub<\/a>. This provided a framework for getting Canvas apps reviewed and ranked but wanted to automate the reviews so that it would do the review as it was being promoted in the pipeline. <\/p>\n\n\n\n

The basic architecture will be like this\n<\/p>\n\n\n\n

\nflowchart TD\n\tsubgraph Tennant\n\tB[1.2.1 - Start App Review] --> |Solution Name & Solution Version & Canvas App Score & Link to Report| C\n\tdirection TB\n subgraph Pipeline Orchestrator\n A[1.2 - When a push to test happens] -->|Solution Name & Solution Version & Stage Run ID & ArtifactID| B\n end\n subgraph Production\n C[Solution History Table]\n end\n end\n<\/div>\n\n\n\n

 <\/p>\n\n\n\n

When a new push to test occurs, a review of the solution will occur. After the review, the output is sent to the PPPM Solution History table. From here we can add the score to the notification sent to the project lead before approving the solution into production. <\/p>\n\n\n\n

Solution History Table<\/h1>\n\n\n\n

Within the PPPM solution, create a new table called Power Platform Solutions History<\/p>\n\n\n\n

\n---\ntitle: Power Platform Solution History\n---\nerDiagram\nSolution_History}| -- || PPPM_Solution_Tracking:contains\n Solution_History {\n string Solution_Version_Name PK\n url Link_to_report\n float App_Review_Score\n float Review_Score\n GUID PPPM_Solution FK\n }\n<\/div>\n\n\n\n

 <\/p>\n\n\n\n

 <\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Power Apps Code Review Tool<\/h1>\n\n\n\n

The Power Apps Code Review tool is comprised of two apps (MDA and a canvas). The MDA is where all the rules and the reviews can be reviewed. The canvas app is where the an amazing showcase for what a canvas app can do. It provides a great interface for Code Reviews Checklists, App Checker, App Overview, Code Review, and Review Results<\/p>\n\n\n\n

 <\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

 <\/p>\n\n\n\n

Within the app I made an update to help with deep linking. <\/p>\n\n\n\n

    \n
  1. Within the AppOnStart I set the AppID to the environment variable the equals the environment variable andy_PowerAppsReviewAppID\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    Set(\n    AppID,\n    LookUp('Environment Variable Values', 'Schema Name' = \"andy_PowerAppsReviewAppID\").Value\n);<\/code><\/pre>\n\n\n\n
     <\/p>\n<\/li>\n\n\n\n
  2. Within the AppStartScreen I updated the If statement to navigate to the SolutionDetailsScreen\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    If(!IsBlank(Param(\"reviewid\")), SolutionDetailsScreen)<\/code><\/pre>\n\n\n\n
     <\/p>\n<\/li>\n\n\n\n
  3. Within the OnVisible of the SolutionDetailsScreen, add an if statement that will set the variable ActiveSolutionReviewID to be either reviewid or SolutionReviewID. Then update the var SelectedSolutionReview and collection SolutionReviewApps. \n\n
    \/\/ Set ActiveSolutionReviewID based on whether the parameter is blank\nSet(\n    ActiveSolutionReviewID,\n    If(\n        IsBlank(Param(\"reviewid\")),\n        SolutionReviewID,\n        Param(\"reviewid\")\n    )\n);\n\n\/\/ Set SelectedSolutionReview using ActiveSolutionReviewID\nSet(\n    SelectedSolutionReview,\n    LookUp(\n        PatchedSolutionReviews,\n        Rev_SolutionReview = GUID(ActiveSolutionReviewID)\n    )\n);\n\n\/\/ Populate SolutionReviewApps using ActiveSolutionReviewID\nClearCollect(\n    SolutionReviewApps,\n    Filter(\n        Rev_Apps,\n        Rev_Apps_SolutionReview.Rev_SolutionReview = GUID(ActiveSolutionReviewID) &&\n        Chx_AppType <> AppType.'Model Driven App'\n    )\n);\n<\/code><\/pre>\n\n\n\n
     <\/p>\n<\/li>\n\n\n\n
  4. The Solution score button in the upper right needs to be updated as well to use the new variable \n\n\n
    \"\"\/<\/figure>\n\n\n\n
    Round(\n    LookUp(\n        Rev_SolutionReview,\n        Rev_SolutionReview = GUID(ActiveSolutionReviewID)\n    ).Nb_SolutionScore * 100,\n    0\n) & \"%\"<\/code><\/pre>\n\n\n\n
     <\/p>\n<\/li>\n\n\n\n
  5. I also updated the header back button to be hidden if the review is not blank. This way the user can only navigate to the report they were sent.\n
    \"\"\/<\/figure>\n<\/li>\n<\/ol>\n\n\n\n
    Pipeline Flow Configuration<\/h1>\n\n\n\n
    1.2 - When a push to test happens<\/h2>\n\n\n\n
    The trigger for the flow will be When an action is performed<\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    To ensure that the trigger only occurs when a push to test occurs, a trigger condition needs to be set. For me, it is the deploy to test stage<\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    @equals(triggerOutputs()?['body\/OutputParameters\/DeploymentStageName'], 'STAGENAME')<\/code><\/pre>\n\n\n\n
     <\/p>\n\n\n\n
    Next will be a Scope with two Dataverse Get row ID actions<\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
     <\/p>\n\n\n\n
    The first will get the stage run information using the stage run id from the trigger<\/p>\n\n\n\n
    triggerOutputs()?['body\/InputParameters\/StageRunId']<\/code><\/pre>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
     <\/p>\n\n\n\n
    The other will get the Deployment Artifact from the action above<\/p>\n\n\n\n
    outputs('Get_a_row_by_ID_-_Deployment_Stage_Runs')?['body\/_artifactid_value']<\/code><\/pre>\n\n\n\n
     <\/p>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    A child flow will be triggered that starts the actual app review<\/p>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    A scope with a condition based on the review status of the app review<\/p>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    Within the True side, add two Dataverse Actions. <\/p>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    The first will get the GUID of the solutions tracking table in the production environment using the name of the Artifact<\/p>\n\n\n\n
     <\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
    The second adds a row to the Solution History table in Production table<\/p>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
     <\/p>\n\n\n\n
    1.2.1 - Start App Review<\/h2>\n\n\n\n
    The 1.2.1 flow is the child flow called from the 1.2.1 flow and start the actual app review<\/p>\n\n\n\n
      \n
    1. The trigger will be a manual trigger that asks for the StageRunID, ArtifactID, ArtifactName, ArtifactVersion\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    2. Next, add a Boolean variable called varStatus\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    3. To get the artifact out of the pipeline a HTTP action\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    4. Within a Scope action four Dataverse Actions are added\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    5. The first will add a new row to the Solution Review table\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    6. The second will upload the file to the Solution Review table\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    7. The third adds a new row to the Review Request table\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    8. The fourth will set the review status of In Progress\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    9. After the Scope another scope is added with a Do Until Action and a Dataverse Action\n
      \"\"\/<\/figure>\n<\/li>\n\n\n\n
    10. The Do until will keep running until varStatus is equal to true\n\n
      \"\"\/<\/figure>\n\n\n\n
        \n
      1. Within the Do until add a delay action, this will give the review time to run<\/li>\n\n\n\n
      2. Next add a Get row by ID of the Solution Review table\n
        \"\"\/<\/figure>\n<\/li>\n\n\n\n
      3. Add a condition that checks to see if the status of the review is done\n
        \"\"\/<\/figure>\n<\/li>\n\n\n\n
      4. If it equals Done or Error and not In Progress then it will set the variable varStatus to true\n
        \"\"\/<\/figure>\n<\/li>\n<\/ol>\n<\/li>\n\n\n\n
      5. The last action within the scope will get the Solution Review record via ID\n
        \"\"\/<\/figure>\n<\/li>\n\n\n\n
      6. The last action within the flow will be to respond to the parent flow with the app review score, the review status, and the reviewid<\/li>\n<\/ol>\n\n\n\n
        \"\"\/<\/figure>\n\n\n\n
         <\/p>\n\n\n\n
        \n\n\n\n
        This was a really interesting post to write. I have always wanted to do \u201creviews\u201d with my teams that do not have ADO or another connected system. In the next post, I will go over how I build a method for doing reviews on Power Automate flows using Power Platform Pipelines.  <\/p>\n","protected":false},"excerpt":{"rendered":"
        A few weeks ago, I was reading on some strategies to do \u201ccode\u201d reviews for power platform solutions. My goal was to figure how to review a solution that was being pushed via Power Platform Pipelines and give the developer and project lead a scoring for how it performed. This got me reading more into […]<\/p>\n","protected":false},"author":1,"featured_media":1303,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,22,30,42,45,37,35],"tags":[],"class_list":["post-1302","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-canvas-app","category-dataverse","category-power-automate","category-power-pipelines","category-pppm","category-security","category-tables","entry","has-media"],"jetpack_featured_media_url":"https:\/\/automatethemundane.com\/wp-content\/uploads\/2024\/12\/photo-1609177338111-c5cb3694d0e9-scaled.jpg","_links":{"self":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts\/1302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/comments?post=1302"}],"version-history":[{"count":2,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts\/1302\/revisions"}],"predecessor-version":[{"id":1305,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts\/1302\/revisions\/1305"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/media\/1303"}],"wp:attachment":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/media?parent=1302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/categories?post=1302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/tags?post=1302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}