FORGOT YOUR DETAILS?

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

Just a few bits that are useful to me when creating apps

For example, if you have the following table:

Search Engine Address
Google www.google.com

And you bind it to a gallery. In the gallery template, you add a text box control, with the following properties:

Text: ThisItem.SearchEngine
OnSelect: Launch(ThisItem.Address)

PowerApps 101: Create your own forms

 

List items:-

[“01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”]

A better search box is as follows:-

Search( PartyContact, TextSearchBox1.Text, “PartyName”)

SortByColumns(Search( PartyContact, TextSearchBox1.Text, “PartyName”),”PartyName”,Ascending)

Filter(Search(SortByColumns(EventsList,”DateTime”,Descending),TextSearchBox1.Text,”Description”),DateTime>=StartDate&&DateTime<=EndDate)

Card controls – for putting into view only mode DisplayMode.View

https://docs.microsoft.com/en-us/powerapps/controls/control-card

Formattting dates for UK

Text(DatePicker1.SelectedDate,”[$-en-US] dddd dd mmm yyyy”)

Details on the patch function

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

PowerApps Embed in Power BI Dashboard

Tuesday, 14 November 2017 by

Note to myself Code required for embedding PowerApps into a Power BI dashboard

<iframe width=”98%” height=”98%” src=”https://web.powerapps.com/webplayer/app?appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX- recover this from your powerapps details pane 

&hideNavBar=true”/>

 

 

PowerApps cascading dropdowns

Sunday, 12 November 2017 by

By far the clearest video on this topic that I’ve seen. Well done Daniel!
 

 

Power BI November 2017 Update

Thursday, 09 November 2017 by

So the November update is out.  Sadly, it doesn’t have the filters across pages which will prove an extremely good way of decluttering a dahsboard.

Here’s a summary of the updates, and what I think of them.

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity

Query editing

For a summary of the major updates, you can watch the following video:

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

Just a few bits that are useful to me when creating apps

For example, if you have the following table:

Search Engine Address
Google www.google.com

And you bind it to a gallery. In the gallery template, you add a text box control, with the following properties:

Text: ThisItem.SearchEngine
OnSelect: Launch(ThisItem.Address)

PowerApps 101: Create your own forms

 

List items:-

[“01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”]

A better search box is as follows:-

Search( PartyContact, TextSearchBox1.Text, “PartyName”)

SortByColumns(Search( PartyContact, TextSearchBox1.Text, “PartyName”),”PartyName”,Ascending)

Filter(Search(SortByColumns(EventsList,”DateTime”,Descending),TextSearchBox1.Text,”Description”),DateTime>=StartDate&&DateTime<=EndDate)

Card controls – for putting into view only mode DisplayMode.View

https://docs.microsoft.com/en-us/powerapps/controls/control-card

Formattting dates for UK

Text(DatePicker1.SelectedDate,”[$-en-US] dddd dd mmm yyyy”)

Details on the patch function

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

PowerApps Embed in Power BI Dashboard

Tuesday, 14 November 2017 by

Note to myself Code required for embedding PowerApps into a Power BI dashboard

<iframe width=”98%” height=”98%” src=”https://web.powerapps.com/webplayer/app?appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX- recover this from your powerapps details pane 

&hideNavBar=true”/>

 

 

PowerApps cascading dropdowns

Sunday, 12 November 2017 by

By far the clearest video on this topic that I’ve seen. Well done Daniel!
 

 

Power BI November 2017 Update

Thursday, 09 November 2017 by

So the November update is out.  Sadly, it doesn’t have the filters across pages which will prove an extremely good way of decluttering a dahsboard.

Here’s a summary of the updates, and what I think of them.

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity

Query editing

For a summary of the major updates, you can watch the following video:

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

Just a few bits that are useful to me when creating apps

For example, if you have the following table:

Search Engine Address
Google www.google.com

And you bind it to a gallery. In the gallery template, you add a text box control, with the following properties:

Text: ThisItem.SearchEngine
OnSelect: Launch(ThisItem.Address)

PowerApps 101: Create your own forms

 

List items:-

[“01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”]

A better search box is as follows:-

Search( PartyContact, TextSearchBox1.Text, “PartyName”)

SortByColumns(Search( PartyContact, TextSearchBox1.Text, “PartyName”),”PartyName”,Ascending)

Filter(Search(SortByColumns(EventsList,”DateTime”,Descending),TextSearchBox1.Text,”Description”),DateTime>=StartDate&&DateTime<=EndDate)

Card controls – for putting into view only mode DisplayMode.View

https://docs.microsoft.com/en-us/powerapps/controls/control-card

Formattting dates for UK

Text(DatePicker1.SelectedDate,”[$-en-US] dddd dd mmm yyyy”)

Details on the patch function

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

PowerApps Embed in Power BI Dashboard

Tuesday, 14 November 2017 by

Note to myself Code required for embedding PowerApps into a Power BI dashboard

<iframe width=”98%” height=”98%” src=”https://web.powerapps.com/webplayer/app?appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX- recover this from your powerapps details pane 

&hideNavBar=true”/>

 

 

PowerApps cascading dropdowns

Sunday, 12 November 2017 by

By far the clearest video on this topic that I’ve seen. Well done Daniel!
 

 

Power BI November 2017 Update

Thursday, 09 November 2017 by

So the November update is out.  Sadly, it doesn’t have the filters across pages which will prove an extremely good way of decluttering a dahsboard.

Here’s a summary of the updates, and what I think of them.

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity

Query editing

For a summary of the major updates, you can watch the following video:

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

Just a few bits that are useful to me when creating apps

For example, if you have the following table:

Search Engine Address
Google www.google.com

And you bind it to a gallery. In the gallery template, you add a text box control, with the following properties:

Text: ThisItem.SearchEngine
OnSelect: Launch(ThisItem.Address)

PowerApps 101: Create your own forms

 

List items:-

[“01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”]

A better search box is as follows:-

Search( PartyContact, TextSearchBox1.Text, “PartyName”)

SortByColumns(Search( PartyContact, TextSearchBox1.Text, “PartyName”),”PartyName”,Ascending)

Filter(Search(SortByColumns(EventsList,”DateTime”,Descending),TextSearchBox1.Text,”Description”),DateTime>=StartDate&&DateTime<=EndDate)

Card controls – for putting into view only mode DisplayMode.View

https://docs.microsoft.com/en-us/powerapps/controls/control-card

Formattting dates for UK

Text(DatePicker1.SelectedDate,”[$-en-US] dddd dd mmm yyyy”)

Details on the patch function

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

PowerApps Embed in Power BI Dashboard

Tuesday, 14 November 2017 by

Note to myself Code required for embedding PowerApps into a Power BI dashboard

<iframe width=”98%” height=”98%” src=”https://web.powerapps.com/webplayer/app?appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX- recover this from your powerapps details pane 

&hideNavBar=true”/>

 

 

PowerApps cascading dropdowns

Sunday, 12 November 2017 by

By far the clearest video on this topic that I’ve seen. Well done Daniel!
 

 

Power BI November 2017 Update

Thursday, 09 November 2017 by

So the November update is out.  Sadly, it doesn’t have the filters across pages which will prove an extremely good way of decluttering a dahsboard.

Here’s a summary of the updates, and what I think of them.

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity

Query editing

For a summary of the major updates, you can watch the following video:

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

Just a few bits that are useful to me when creating apps

For example, if you have the following table:

Search Engine Address
Google www.google.com

And you bind it to a gallery. In the gallery template, you add a text box control, with the following properties:

Text: ThisItem.SearchEngine
OnSelect: Launch(ThisItem.Address)

PowerApps 101: Create your own forms

 

List items:-

[“01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”]

A better search box is as follows:-

Search( PartyContact, TextSearchBox1.Text, “PartyName”)

SortByColumns(Search( PartyContact, TextSearchBox1.Text, “PartyName”),”PartyName”,Ascending)

Filter(Search(SortByColumns(EventsList,”DateTime”,Descending),TextSearchBox1.Text,”Description”),DateTime>=StartDate&&DateTime<=EndDate)

Card controls – for putting into view only mode DisplayMode.View

https://docs.microsoft.com/en-us/powerapps/controls/control-card

Formattting dates for UK

Text(DatePicker1.SelectedDate,”[$-en-US] dddd dd mmm yyyy”)

Details on the patch function

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

PowerApps Embed in Power BI Dashboard

Tuesday, 14 November 2017 by

Note to myself Code required for embedding PowerApps into a Power BI dashboard

<iframe width=”98%” height=”98%” src=”https://web.powerapps.com/webplayer/app?appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX- recover this from your powerapps details pane 

&hideNavBar=true”/>

 

 

PowerApps cascading dropdowns

Sunday, 12 November 2017 by

By far the clearest video on this topic that I’ve seen. Well done Daniel!
 

 

Power BI November 2017 Update

Thursday, 09 November 2017 by

So the November update is out.  Sadly, it doesn’t have the filters across pages which will prove an extremely good way of decluttering a dahsboard.

Here’s a summary of the updates, and what I think of them.

Here’s the complete list of November updates:

Reporting

Analytics

Data connectivity

Query editing

For a summary of the major updates, you can watch the following video:

TOP