FORGOT YOUR DETAILS?

PowerApps Crib Sheet

Wednesday, 15 November 2017 by

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

 

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

 

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

 

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

 

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

 

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