Tuesday, December 26, 2023

Sharing PowerApp with external user

 Create an external user in portal.azure.com.\

User will recieve an email he/she have to accept the invitation link.

Assign powerApps license to that user.

Share the App as normally to that external user.

Pipeline configuration

 https://learn.microsoft.com/en-us/power-platform/alm/set-up-pipelines

https://learn.microsoft.com/en-us/power-platform/alm/run-pipeline

  • Host environment. This special-purpose environment acts as the storage and management plane for all pipeline configuration, security, and run history.

  • Development environment. This is where you’ll develop solutions. A pipeline can be run from within any development environments linked to it.

  • Target environment. The destination environment(s) a pipeline deploys to. For example, integration testing, UAT, production, etc.

Install the Power Platform Pipelines application in your host environment
Play the Deployment Pipeline Configuration app, Create New environments for development and target.

Next create Pipeline & add the developer registered environment.

Then create stage & specify the target environment environment, then go to the solution. Select Deploy from the left navigation menu.

This will start a wizard, specify connections & environment variables.





Monday, December 25, 2023

Website templates

https://themewagon.com/theme-category/admin-dashboard/ 


https://themewagon.com/themes/free-bootstrap-5-admin-dashboard-template-darkpan/

Download the template and create the app accordingly with all the pages


https://themewagon.com/themes/free-responsive-bootstrap-4-html5-admin-template-tinydash/


https://themewagon.com/themes/elearning-free-bootstrap-5-css3-education-website-template/

App Background

 https://www.svgbackgrounds.com/set/free-svg-backgrounds-and-patterns/

https://heropatterns.com/


https://bgjar.com/animated-shape ( Get code , copy data URI)

https://bgjar.com/shiny-overlay

Hola SVG Loaders - Free SVG Loader Generator

Tuesday, December 19, 2023

Azure AD secured Azure Function Custom Connector

 https://learn.microsoft.com/en-us/connectors/custom-connectors/create-custom-connector-aad-protected-azure-functions

Sunday, December 17, 2023

Upload multiple files in dataverse using powerapps

 Microsunlight_Products_Supporting_Docs is the table containing multiple files for a product, since in dataverse file column can have only one file, Microsunlight_Products_LookUp is the lookup field.


ForAll(

    col_AllAddDocs As MyAttachment,

  

    Patch(

        Microsunlight_Products_Supporting_Docs,

        Defaults(Microsunlight_Products_Supporting_Docs),

        {

            ID: MyAttachment.Name,

            Microsunlight_Products_LookUp: LookUp(Microsunlight_Products, Microsunlight_Product = _NewItem.Microsunlight_Product) ,

            Doc: {

                FileName: MyAttachment.Name,

                Value: MyAttachment.Value

            }

        }

    )

);

Clear(col_AllAddDocs);


On attachment addfile, removefile, undoremovefile add

ClearCollect(col_AllAddDocs, Self.Attachments)


Upload file in dataverse from powerapps

  Patch(

        Microsunlight_Products,

        Defaults(Microsunlight_Products),

        grmMSProducts.Updates,

        {

            SupportingDocs: {

                FileName: First(DataCardValue7.Attachments).Name,

                Value: First(DataCardValue7.Attachments).Value

            }

        }

    )

Tuesday, December 12, 2023

Upload file to dataverse using flow

 In the app:

UploadFileToMicrosunlight_Products.Run(

    var_selectedItem.Microsunlight_Product,

    {

        file: {

            contentBytes: First(DataCardValue7.Attachments).Value,

            name: First(DataCardValue7.Attachments).Name

        }

    }

);

UpdateContext({var_refrsh:true});



Download file from dataverse field

 Download("https://org98191ad6.crm8.dynamics.com/api/data/v9.2/cr539_microsunlight_products("&ThisItem.Microsunlight_Product&")/cr539_supportingdocs/$value")


ThisItem.Microsunlight_Product is the guid field (default)


cr539_microsunlight_products is your plural name of table

cr539_supportingdocs is the file field



Download image from Dataverse Image field

 Download("https://org98191ad6.crm8.dynamics.com/Image/download.aspx?Entity=cr539_microsunlight_product&Attribute=cr539_product_main_image&Full=true&Id="&ThisItem.Microsunlight_Product)

ThisItem.Microsunlight_Product is your guid default column


Add Service Principle support in Custom Connector

  then search for "Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Applicati...