Skip to main content

Posts

SurveyJS and PowerApps Portals [Part 4]

To call Web API we will need to call webapi.safeAjax function which accepts one argument ajaxOptions which is a standard object with properties for ajax request. Please refer the Microsoft documentation In this snippet, we are referring all the libraries required for SurveyJS to render the data and store responses provided by the user in an object (which we use to store in d365 CE tables). We have created a div element to render the form on the portal and another div element to show a customized message on the portal. In this snippet - on document.ready, we are calling a function getSurveyData() to render the data on to the portal, initializing the methods (out of the box in SurveyJS) to capture the data on Complete button click and Next page button click on the form. To render the data, we are making a Web API call to the Dynamics from PowerApps Portals and passing that JSON object into Survey object. Refer SurveyJS documentation for more details. In this snippet - we have created me
Recent posts

SurveyJS and PowerApps Portals [Part 2]

   Dynamics 365 CE [to host the forms data] For this scenario, we have created below Table and Column components. Table -  Forms Payload Columns -  SurveyJS Payload  and  SurveyJS Response SurveyJS Payload:  column to store the JSON object of an assessment form. SurveyJS Response:  column to store the responses provided from the PowerApps Portals. We use the JSON object available in the "SurveyJS Payload" column from the PowerApps Portals using Web API to generate SurveyJS form to provide responses by the end user. SurveyJS and PowerApps Portals [Part 3]

SurveyJS and PowerApps Portals [Part 1]

  SurveyJS   is an open-source survey and form library for JavaScript that allows you to create customizable surveys and forms for collecting user feedback or data.   SurveyJS   provides a simple and intuitive way to design and manage surveys and forms using a variety of question types, such as multiple choice, rating, dropdown, and text fields. SurveyJS  would be a good tool to reply upon when it is needed to create assessment forms/ feedback forms from Dynamics 365 CE and PowerApps Portals. In this post, let us see how to leverage  SurveyJS  in PowerApps Portals without any APIs.  No major pre-requisites are required, except basic understanding of PowerApps Portals  and jQuery. Get Started: Create a Web Page in PowerApps Portals. Create a Page Template in PowerApps Portals. Create a Web Template in PowerApps Portals. Create a Web Template in PowerApps Portals: Open the "Portal Management" app from Apps section on the left navigation at https://make.powerapps.com. Go to Port

SurveyJS and PowerApps Portals [Part 3]

  Web Template implementation- to generate and capture Assessment Forms from Dynamics Table created in the 2nd part of this topic.    Go to the Web Template created in the 1st part of this topic and paste the below snippet into it <script>     ( function ( webapi , $ ){             function safeAjax ( ajaxOptions ) {                 var deferredAjax = $ . Deferred ();                         shell . getTokenDeferred (). done ( function ( token ) {                     // add headers for ajax                     if (! ajaxOptions . headers ) {                         $ . extend ( ajaxOptions , {                             headers : {                                 "__RequestVerificationToken" : token                             }                         });                     } else {                         ajaxOptions . headers [ "__RequestVerificationToken" ] = token ;                     }                     $ . ajax ( ajaxOptions )              

Get old SharePoint Files using Power Automate efficiently

In this post, let us see how can we get the old files from a SharePoint Folder using Power Automate. In this example, I am considering a simple approach and this can be extended based on the requirement. To ensure the Power Automate is simple, efficient and the performance is optimized - we are not using ForEach control to loop through and identify old file or item.  We use " Send an HTTP request to SharePoint " in the Power Automate and query the data using OData filters and order by.  The idea here for the faster retrieval - selecting only a required set of fields from the file. Steps to achieve this: Login to https:make.powerautomate.com . New Cloud Flow -> Scheduled Or Instant (based on the requirement). (Configure the Start Date and Time. For repeat, every, configure the seconds/ minutes/  hours/ day/ week/ month) Click on Create Button. Click + icon to add new action. Search for SharePoint and select  " Send an HTTP request to SharePoint " Select the respec