Search Application using power automate with canvas app.

 

In this Power Apps Tutorial, We will discuss how to get data from Dynamic 365 using MS Flow. it’s syntax, how to use the Power automate and return data to canvas app.

We will also see how to search button with work do display items from the Data vase Account Entity using the Power automate  to canvas app.

Step 1: We will Create MS Flow to get data from dynamic 365 account entity and send response to canvas app.

Navigate to https://make.powerapps.com/

Once above link opened please click on flows from left navigate and click on new flow.



Give Flow name based on requirement and select PowerApps.


Next steps to create two variables Name, City because our application will search based these two inputs.



Please select  list rows as next step in power app where we need to select our entity (Ex: Account entity) and click on show advanced options to write Fetch XML what we have download from advance find from CRM.



We can get the counts of records, create one variable and give this formula “@length(body('List_rows')?['value'])” as per blow screen.


Next sept is create compose and Body in inputs field.


Now we need add step parse JSON , in content  field add Outputs as value and Generate our JSON Structure.

Note: if don’t know how to generate JSON please run the flow till above compose step and take output and generate JSON.


Now we need to apply each condition to map fields from output what we are getting, please fellow below screen.


Final step we need to response and in Body column and Value and click on Show advanced option and generate JSON template.




Final MS Flow how it will look for reference.


Step2 :

Create canvas app and design your app as per below screen.


Next step we need to bind our MS Flow when click on search button, please find below screen shot.



Add Data Table to Canvas do display search results


In item property enter FlowOutput  because while binding flow we have set variable FlowOutput to get response from MS flow.

Click on Edit field and your fields in data table based on your needs.



Final Screen with output
















 


























Comments

Post a Comment

Popular posts from this blog

How to implement approval in Teams using Adaptive Cards

Image
  Adaptive Cards are self-contained user interface components that transcend platform boundaries. Crafted in JSON format, these snippets of UI can be seamlessly exchanged between applications. Upon reaching a particular application, the JSON content is dynamically rendered into native UI elements, seamlessly blending with the app's aesthetic. This approach facilitates the creation and seamless integration of lightweight UI elements across diverse platforms and frameworks. User Story: We're preparing to implement a leave approval workflow in Teams utilizing adaptive cards. Employees will submit their leave requests, and line managers will receive notifications within Teams. Step 1 – Design the Adaptive Card Prior to establishing the flow, let's initiate the card design process using the designer tool to ensure readiness. Visit https://adaptivecards.io/designer/   to access the designer interface and adjust the 'host app' setting to Microsoft Teams – Light /
Read more

Open canvas app with Customize the command bar using command designer

Image
  This topic guides you through creating and editing modern commands using the command designer and Power Fx. Create a new model-driven app using modern app designer 1.      Sign into  Power Apps 2.      On the left navigation pane, select  Solutions  and then open or create a solution to contain the new model-driven app. 3.      Select  New  >  App  >  Model-driven app 4.      Select  Modern app designer , and then select  Create .    Enter a  Name  for your app, and then select  Create . More information:  Create a model-driven app that has an account table page 1.      On the left navigation pane, select  Solutions , and then open the solution containing the existing model-driven app. 2.      Select the model-driven app, and then select --  >  Edit  >  Edit in preview  to open the modern app designer. 2.      Click on Add page 3.      Based on your requirement select either options, I have selected Customer(preview) as per my requirement. 5. We need to select o
Read more

HTTP Request Methods

Image
  1. π—šπ—˜π—§ : GET Method is used to request information from a website, Server or from API. Example: GET/api/employee/{employee-id}   2. 𝗣𝗒𝗦𝗧 : POST Method is used to create a new resource in server. We can send data to the server in the request body. Example: POST/api/employee/department   3. 𝗣𝗨𝗧 : PUT Method is used to update an existing record by sending the updated data as the content to request body to the server. Example: POST/api/employee/55445   4. π——π—˜π—Ÿπ—˜π—§π—˜ : DELETE Method is used to remove resources from the server. Example: DELETE/api/employee/55445   5. 𝗣𝗔𝗧𝗖𝗛 : PATCH and PUT are similar use to updates a resource, but it will update data partially but not fully. Example: PATCH/api/employee/55445{"Name: Employee Name"}   6. π—›π—˜π—”π—— : HEAD Method is like the GET but it doesn't have any response body. Example: HEAD/api/employee   7. π—’π—£π—§π—œπ—’π—‘π—¦ : OPTIONS Method is used to get the information about the possible
Read more

Create email templates in dynamic 365 and send email using Power Automate

Image
We can utilize email templates with Power Automate to send emails. Follow these steps to use email templates with Power Automate. ·         Create Email Template in dynamic 365. ·         Configure Power Automate to Email Template. Create Email Template in dynamic 365: Navigate to Power Platform admin center, navigate to the Environments tab, and select your environment you wish to create email template refer below screen short. Click on setting and look for Templets and click on Email Template. Click on new on tool bar. The Email Template Type dialog box will open. Select the desired entity and then click OK. On the template form, provide a name for your email template and, if desired, add a description. Note that the email template name and description will not be visible to the recipient. Enter the text you want to send in the message. Use the formatting toolbar to edit and style your text. Ensure your grammar is correct and make the formatting visuall
Read more

Duplicate Detection in Dynamics 365 using power apps.

Image
  User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address. Step 1 :  Navigate to make.powerapps.com, screen 1 Γ  Create a Blank Canvas App Γ  Connect with Dynamics 365 Data Source Γ  Connect Contact Entity as Dataset (You can connect other entity also as per your requirement) Step 2:   Screen 2 - Insert a new Blank Screen to show Duplicate Detection Dialog Step 3:   Add few Text Input and Button Controls in Screen 1 or design as per your need. Step 4:  Add below formula on Button Control (onSelect property) to find Duplicate Record. If ( IsBlank ( LookUp ( Contacts , emailaddress1 = Emailaddress_Text . Text )), UpdateContext ({ result: "Duplicates Record not found" }), Navigate ( DuplicateDetectionDailogbox , ScreenTransition . CoverRight ) ) ; You can use following formula also on Button Control (onSelect property) to find Duplicate
Read more