Java Script Task-5 : Call power automate on click on approve button and send the email to parents

 User Story: If you click on the approve button approve status should get approved and send the mail to parents by using power automate achieve this scenario

1)      Open Power apps (make.powerapps.com)

2)      Create one Http request

·         Add step as Send Email

3)      Create One Approve Button By using Ribbon work bench

4)      By using CRM Rest Builder retrieve the Parent Email address

5)      Write a Java Script Code by using CRM Rest Builder provided Code

In java script code:

·         Retrieve the approval status

·         Give the null check as if approval status is not equal to Approved

·         Then set the value as Approved and retrieve the Parent

·         Here again give the null check as if parent email !=null then by using XML Http request send the mail to parent.

6)      Create one Web Resource and Add Java script code in to this Web Resource

7)      Add this web Resource to Approved Button



Create one Approve button

When you click on Approve button Approve status will update to Approved

Click on Button command then below window will opened

 click on Action and enter

Library: Enter Web Resource Name

Function Name: Enter Java script function Name

Click on Add parameter and choose Primary control

Click on Publish


Code:


Click on create Request then below code will generates


 

  function statusApprove(primarycontrol) {

    var formContext = primarycontrol;

    var status = formContext.getAttribute("effi_approvalstatus").getValue();

   

    if (status != 1) {

        formContext.getAttribute("effi_paapprovalstatus").setValue(1);

    // Here 1 is the Option set Approved value

        var Parent = formContext.getAttribute("effi_parent").getValue();

        var name = Parent[0].name;

        var id = Parent[0].id.replace("{", "").replace("}", "");

 

        Xrm.WebApi.online.retrieveRecord("contact", id, "?$select=emailaddress1").then(

            function success(result) {

                var Email = result["emailaddress1"];

                if (Email != null) {

                    var req = new XMLHttpRequest();

                    var url = "https://prod-15.centralindia.logic.azure.com:443/workflows/41cead4e35cf400e92797cfe8f5478b1/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=QR6SixpZrLp4OxPxxQsSR13cOcmPWOoI5xBlnqDwb-k";

                    req.open("POST", url, true);

                    req.setRequestHeader('content-Type', 'application/json');

                    req.send(JSON.stringify({

                        "Parent": name,

                        "Email": Email

 

                    }));

                }

            },

            function (error) {

                Xrm.Utility.alertDialog(error.message);

            }

        );

    }  

    }

Comments

Post a Comment

Popular posts from this blog

SSRS User Story-7: Create a SSRS report group by Case, retrieve all work orders and make work orders as sub group, retrieve all bookable resource bookings based on work order. If booking is completed then show the row color as green.

Image
Entities: ·          Cases ·          Wok Order ·          Bookable Resource Booking Fetch xml for retrieving cases which does not contains Work Orders (or) choose contain work Orders data: If you choose contains data then in fetch xml in link entity, link type shown as Inner If you choose does not contain data then in fetch xml in link entity, link type shown as Outer . In this scenario we need all work Orders that’s why choose link type as Outer In this below fetch xml code need to remove filter condition Here also need to remove filter condition   Final Fetch xml: Here am writing one link entity data into another link entity Need to pass a from as attribute from link entity < fetch version = " 1.0 " output-format = " xml-platform " mapping = " logical " distinct = " true " >      ...
Read more

SSRS User Story 2: Generate a report on individual student, if I click on the payment details report in student record. It need to show all the transactions done in current year along with sum. (it should show for each student separately)

Image
  Entities: ·          Student ·          Transaction Fields :             Transaction: o    Student Name (Lookup of student entity) o    Amount   Report Creation : Right click on Project à Add à New item Here enter the Report Name and click ok Add Right click on the Data Sources choose Type as Microsoft Dynamics 365 Fetch Connection String : Enter your CRM URL and click on ok Click on the Credentials Enter User name and Password click on Ok Then Data Source is created Right click on the Data Source and choose Add Data Set      Fetch xml for all Transactions in current from linked from student:     Double click on data set name (Transaction) Then below window will be opened. choose Data Source. Choose Query type as Text. Here Ente...
Read more

SSRS User Story-8: Create a SSRS report on the Opportunity entity, show the source lead and campaign details.

Image
  Entities: ·          Opportunity ·          Lead ·          Campaign ·          Need to Create Run Report Button in Opportunity entity Create Campaign Record: Create Lead record: Create a lead record and choose Source campaign as above created campaign. Click on lead qualify button then lead is converted into opportunity.     Opportunity record: Note : Run report button is not available in Opportunity entity form. Need to Create Run Report Button Need to create one solution and add account entity and opportunity entity Solution creation: Adding entities into solution: Open XRM Tool box and create Button: Here copy the Run Report Button from account entity Paste the Run report button on Opportunity entity Fetch Xml for retrieving lead and campaign details f...
Read more