Microsoft Dynamics 365 – Page 225 – Nishant Rana's Weblog

PowerApps in CRM 2016 (Microsoft Dynamics 365)

Let us quickly create a PowerApp that allows a user to create Contact record inside CRM (using Microsoft Flow).

https://web.powerapps.com/home

Click on New app

Let us use PowerApps studio for Windows here (much easier to use then PowerApps for web)

Select a Blank App (Phone Layout)

Insert Text Box, Text Box Input and Button controls and apply Theme

Select Add to CRM button and select Flow in Action menu to connect with the flow.

Create a new Flow

Search for PowerApps

Select Add an action

Select “Create new a record” Action and select Contacts in Entity Name.
For Last Name field, click on “Ask in PowerApps” which will add a new field to be mapped inside PowerApps

Do same for mobile phone field

Click on Create flow to create the flow

Now back in PowerApps, select the newly created flow.

Specify formula to map the fields

Run the application

Specify the values for Last Name and mobile number and click on Add to CRM button.

This creates the contact record in CRM using the Flow defined.

We can save the app in cloud and the share it with the other users inside the org.

Click on Share (Enter name or email addresses of the users with whom we’d like to share the app)

App being published

Once Published, it would be available to the other users.

Hope it helps..

“Create Dynamics Leads based on Tweets” using Microsoft Flow in CRM 2016

Microsoft Flow is a workflow management tool, using which we can create automated workflows between various services and apps.

With Dynamics CRM Online common scenarios could be

Create Dynamics CRM Leads from an Excel table.
When an opportunity is created post to Yammer.
Copy new Dynamic CRM Account to Common Data Model etc.

https://flow.microsoft.com/en-us/

https://flow.microsoft.com/en-us/services/shared_dynamicscrmonline/dynamics-crm-online/

Below are some of the templates available for CRM Online

Let us take a Template that creates Leads based on Tweets

Connect to both the services

Configure it, for e.g. search for #msdyn365, get the Tweeter User Name and create the lead record. Map topic in lead with tweet text.

Check the status of the flow.

Leads created in CRM

Hope it helps..

How to – Dynamically add rows and columns to Grid View

Hi to add rows and columns to Gridveiw dynamically what
we will do is that

1) Create a DataTable object to which than we will bind the GridView
DataTable dt=new DataTable();

2) IF you need two columns than create two DataColumn object
DataColumn dCol1=new DataColumn(FirstC, typeof(System.String)); // string FirstC=”column1″
DataColumn dCol2=new DataColumn(SecondC, typeof(System.String)); // string SecondC=”column2″

Add it to the table

dt.Columns.Add(dCol1);
dt.Columns.Add(dCol2);

3)Run the loop for as many rows you want to add.

// say you want to add two rows

for(int i=0;i<2;i++)
{
DataRow row1 = dt.NewRow();
row1 [FirstC] = “One”;
row1 [SecondC] =”Two”
dt.Rows.Add(row1 );

}

Now iterate through each datacolumn and create a BoundField foreach column

foreach (DataColumn col in dt.Columns)
{
BoundField bField = new BoundField
bField.DataField = col.ColumnName;
bField.HeaderText = col.ColumnName;
GridView1.Columns.Add(bField);
}
GridView1.DataSource = dt;
//Bind the datatable with the GridView.
GridView1.DataBind();