PowerApps Currency Formatting examples

So far I feel that currency formatting in PowerApps seems to be a little troublesome. Sure everything would be great if we all sold in $ and our offers were all huge! All of the examples out there are based on this. I needed to represent values at 1 NOK and up. In Norway we don’t use “,” for separating thousands.

I am sure there are simpler ways of doing this, and I am hoping someone can fill me inn:)

For US formatting I found this one:

Text(CurrencyField,"[$-en-US]$###,###")

For UK formatting I found this one:

Text(Value(Parent.Default),"[$-en-US]£#,###.00")

For me I need to format PowerApps currency NOK. I have tried manipulating all of the above with no luck at all. Have no idea what I am doing wrong, but that doesn’t matter. I finally found one that worked for me

NOK PowerApps Currency Formatting:

Text(ThisItem.'Est. Revenue',"[$-nb-NO]## ### kr", "nb-NO")

None of this is really making much sense to me. If you have more information about this, please do share!!:)

Dynamics 365+ To-Do = LOVE

There are several To-Do type programs out there, and everyone seems to have their own preference to what is the best tool to use. I will argue why To-Do is the best one for Microsoft users, and why Dynamics and To-Do now makes sense.

A video of To-Do if you are not familiar with the application:

I use To-Do as a tool in my every day work with Outlook and Dynamics. For this to work it is important that you have naming convention in place when working with Dynamics 365 and tasks.

Opportunity

On the opportunity I add a task that has a due date. I prefer to not use the use phone call, because tasks are pretty much the same thing. In my company we don’t have a CTI integration, and we don’t report on number of phone calls.

Outlook

I am using server side sync in D365, so during the next sync my task will appear in Outlook with a view over my tasks. That is fine and all, but if you are like me, the reminders in outlook is full of tasks and calendars. It is too hard to keep track.

To-Do

Now if you open To-Do, you will notice that it also has the list of tasks from CRM 🙂 Because there is no integration with Dynamics lookups, I use the names to remind me what the task was regarding.

When done, I close the task, and CRM is updated with a complete task.

To-Do is available as applications on all devices, and that is why I favor this application. They are continuously adding functions, to integrate it further with all Microsoft products. They are also working on integration with Planner so we can use one app for all tasks no matter where we are!!!

Installing SharePoint connector Dynamics 365 Online

The SharePoint standard connector will work for customers with simple needs for collaboration. There is a Teams integration available soon, and I will write about that once it is released in Europe.

Start off by creating a new site in SharePoint. I prefer to create everything on a new site, because then we can control the site better.

Copy the URL of the site before you move on back to CRM.

I prefer to create folder for the entities Account and Opportunity. Remove all the other entities in the simple demo (not that it really matters).

I prefer to have a structure based on account. This will create opportunity folders bellow the account folder.

If it all worked out, you can now open an opportunity with account connected.

Opening the document on opportunity will now give full access to storing documents in SharePoint. I will write an extended blog about considerations to make when integrating this to Teams later.