Introduction:
In this Blog we will see how to convert String to Number using Power Automate
Implementation Steps:
Power Platform, Microsoft Dynamics CRM 4.0, 2011, 2013, 2015, 2016, D365 CE, C#, ASP.net and MVC, Azure
Introduction:
In this Blog we will see how to convert String to Number using Power Automate
Implementation Steps:
1. Navigate to https://flow.microsoft.com
2. Click My Flows --> Click New Flow --> Select Instant Cloud Flow (You can select based on your needs)
3. Input Flow Name and Select PowerApps as Trigger
4. Click Create
5. Click Add Step --> Search for Variables --> Select Initialize Variable --> Input Name and Select Type as String and Value as "10"
6. Then Again Click Add Step and Select Initialize Variable Again and Input Name and Select Type as Integer
7. Write below Expression to Convert string to Integer
int(variables('STRING Values'))
8. Click Save --> Click Test (at the Top Right)
9. Select Manually --> Click Test --> Click Run Flow --> Then Click Done
10. That's it
Introduction:
In this Blog we will see how to Change Radio Button layout from Vertical to Horizontal in Canvas App.
Implementation Steps:
1. Navigate to https://make.powerapps.com
2. Click Apps
3. Click New Apps --> Select Phone or Tablet Mode
4. Input Name for the Apps and Click Done
5. Once the Page Loaded --> Click Insert and Radio Button
6. Once the Radio button added the LAYOUT for the Radio button will show in Vertical Manner
7. Now if I want to change it to Horizontal Manner --> We need to Select Layout as Horizontal
Change Value From :
To:
That's it
Introduction:
In this Blog we will see how to set Model Driven App theme in PowerApps Canvas
Implementation Steps:
Model Driven Apps:
1. Navigate to https://make.powerapps.com
2. Click Gear Icon at the Top --> Select Advance Settings
3. Once the Page Loaded --> Click Customization --> Select Theme --> You will see Default Theme ( You can see only one default theme for an Application)
COPY THE NAME OF THEME
4. Now go to https://make.powerapps.com
5. Click App --> And Provide the Name for the App and select Tablet or Phone Mode based on your needs --> In this i have selected Tablet Mode
6. Click DataSource --> Select Theme DataSource
7. Once the DataSource Added In the On Start of App Paste the below code
Set(getThemeValues,LookUp(Themes_1,'Default Theme'='Default Theme (Themes_1)'.Yes));
8. Add Multiple Labels in the Form
9. Now Based on the Theme we can load the values(getThemeValues)
10. Now Add one by one to the LABEL : FILL and Label Text
ColorValue(getThemeValues.'Legacy Accent Color')
ColorValue(getThemeValues.'Navigation Bar Fill Color')
11. Based on the Above code we can use the color in different places according to Model Driven App
Final Output
That's it
Introduction:
In this blog, we will see how to Retrieve IP Address for Microsoft Flow
Scinario:
I want to get Response from WebService, that service is restricted to some of the IP Address. I need to get that Service Using Microsoft Flow, So i need to get IP Address of Microsoft Flow to add that IP Address manually to service to get the values.
Let's see how we can achieve this.
Implementation Steps:
1. Navigate to https://flow.microsoft.com
2. Click New App --> Select Instant Cloud Flow
3. Input Name For the Flow and Select PowerApps
4. Select HTTP Trigger
5. Select Method as GET and Input URI as
https://api.ipify.org/?format=json
6. Now Save the Flow
7. Click Test at the Top Right and Select MANUAL trigger --> Select Run Workflow
That's it
8. You can see the IP address in BODY of result.
Introduction
In this Blog we will see how to retrieve More than 256 Rows from Excel using Microsoft flow
Implementation Steps:
1. Create an Excel or Upload the Existing Excel in OneDrive.
2. Open the Excel and Check How Many Rows Available. in my case i have 373 Rows Available
3. I Uploaded it in OneDrive
4. Once Done ---> Navigate to https://flow.microsoft.com
5. Click Instant Cloud Flow and Select PowerAutomate and Input Name for the Flow
6. Once Clicked On Create --> Select Excel Online (Business) --> Then Choose List Rows Present in Table
7. Then Select the location Where the Excel is Available
8. Now for Testing Purpose i will Add a Apply For Each to Check How Many Rows its Retrieving.
9. Now We are done --> Click Test --> And Expand Apply to Each
10. Now you can see only 256 Record Retrieved
11. Let's See how we can change this
12. Click On Three Dots in Excel (List Rows Present in the Table) and select Settings
13. Turn On Pagination and Select Threshold Value to 1000(it Depends) and Click DONE
15. Now --> Save the Workflow and Test Again
16. Now you can see all the Rows from Excel.
That's it
Introduction:
In this Blog we will see how to Concatenate String in Canvas PowerApps
Implementation Steps:
1. Navigate to https://make.powerapps.com
2. Click Apps --> Click New --> Select Canvas App --> Then Input Canvas Name and Select Tablet or Phone and Click Ok
3. Add a Label Field By selecting Insert
4. Using C# or Any Other Code we can Simply Concatenate the Values like below
5. But in Canvas we need to use it in Different way
Lets see how we can Concatenate in Canvas PowerApps
Instead of using + we need to use & Operation for Concatenating the String values
"Hi"&" Welcome"&" to"&" PowerApps"
That's it
Introduction:
In this Blog, we will see how to clone OOB/Custom Entities in Dataverse or MSCRM Environment.
Scenario:
Consider I have an Opportunity Entity Available, once the Opportunity is WON or LOST, we want to Clone that Opportunity with Exact Same Details.
Let's see how we can achieve this.
Note:
This Code is not only Restricted to OOB Entity, we can use this code in Custom Entity too
Implementation Steps:
You can write the below code in your Plugins.
Entity getOpprotuntiyRecord = (Entity)context.InputParameters["Target"];
Entity cloneRecord = service.Retrieve("opportunity", getOpprotuntiyRecord.Id, new ColumnSet(true));
cloneRecord.Attributes.Remove("opportunityid");
cloneRecord.Id = Guid.NewGuid();
Guid getCreatedOpportunity = service.Create(cloneRecord);
In the Above Code i mentioned as
opportunity --> Change it based on your Entity Logical Name
opportunityid --> Entity Logical Name Primary Unique id name
That's it
If Suppose you want to add some value to NAME Field while Cloning means you can write below code
Entity cloneRecord = service.Retrieve("opportunity", getOpprotuntiyRecord.Id, new ColumnSet(true));
cloneRecord.Attributes["name"] = cloneRecord.Attributes["name"].ToString() + " Renewal";
cloneRecord.Attributes.Remove("opportunityid");
cloneRecord.Id = Guid.NewGuid();
Guid getCreatedOpportunity = service.Create(cloneRecord);
You can Just Add the LOGICAL NAME while replacing.
Introduction: In this Blog we will see how to Run Microsoft Flow for Every one Month. Implementation Steps: 1. Navigate to https://make.p...