Related sites:

Newsletter: Perspectives on Power Platform

Company: Niiranen Advisory Oy

Jukka Niiranen blog

Newsletter

Jukka Niiranen blog

Tag Excel

Power Apps, Tips

Using CSS color names for SVG icons in Power Apps Canvas app

In addition to standard color picker options, Power Apps also supports CSS color names to define the appearance of text and icons. To make these color names work in conjunction with our custom SVG icon library from the previous blog post, let's also build a custom color picker for grouping and visualizing the available colors inside Canvas apps.

January 19, 2020
Canvas apps colors CSS Excel icons PowerApps visualizations

Power Apps, Tips

Using SVG icons in Power Apps Canvas apps

To create high quality visualizations for apps that can both scale to high resolutions as well as be dynamically manipulated via formulas, Scalable Vector Graphics (SVG) would be a great choice for Canvas Apps. While there is no native support for SVG features in Power Apps, you can bring in their XML definition and work with it to create a gallery to browse a complete library of icons imported from open source repositories like GitHub.

January 12, 2020
Canvas apps Excel GitHub graphics icons open source PowerApps visualizations

Tips

Access Option Set Labels in Dynamics CRM OData Feeds via Power Query

If you’re using Dynamics CRM Online without direct access to the underlying SQL Server database, there may have been a few occasions when you’ve wished for more flexible options for reporting and customer data analytics than what is possible via configuring CRM…

August 12, 2014
analytics cloud CRM 2013 Excel OData online Power BI Power Query Power View PowerPivot reports

Tips

Dynamics CRM OData Feeds and Power Query: What’s the [Record]?

Now that Power BI has hit the GA milestone (general availability), I decided to spin up a trial subscription for it and get familiar with the tools that it offers. My previous experiment with connecting to CRM Online OData feed with…

February 16, 2014
analytics cloud CRM 2013 Excel OData Power BI Power Query Power View PowerPivot reports

Tips

Connecting to CRM Online OData feed with Excel 2013 Power Query

The latest version of Excel contains a Get External Data menu option for linking the workbook to an OData data feed. Knowing that Dynamics CRM 2011 and 2013 both provide an OData endpoint, this would seem like a great option…

December 15, 2013
analytics cloud CRM 2011 CRM 2013 Excel OData online Power BI PowerPivot reports

Features, Tips

Dynamics CRM Data Visualization with Excel 2013 GeoFlow

There are some great new features available in Excel 2013 that can take your Dynamics CRM data visualization onto a whole new level without the need to invest in new server infrastructure or build traditional OLAP cubes on your SQL…

June 19, 2013
CRM 2011 Excel map OData online Power View PowerPivot reports