Setup Dynamics 365 Trial with Marketing App in Same Organization

Hi all,

I am trying to setup trial for a training that will need both Customer Service, Sales, and Marketing together, however, everytime you setup a trial from this URL:

https://dynamics.microsoft.com/en-us/dynamics-365-free-trial/

It will then create new organization and that means the data won't be shared, it is perfectly aligned with this article:

https://docs.microsoft.com/en-us/dynamics365/customer-service/trial-faq#can-i-sign-up-for-multiple-dynamics-365-apps-such-as-sales-marketing-and-customer-service

I try to "Get Free" each application and then it created multiple environment for me:

But, I want to install Marketing in the Environment 1, the one I created first which already had Customer Service, Field Service, and Sales Hub. Currently, it is in 2 different environments.

This what I learned that make it happens.

1. You need to setup trial

https://dynamics.microsoft.com/en-us/dynamics-365-free-trial/

2. I suggest to start with Customer Service because it has many things inside

3. Then, you can setup the Marketing Trial (which is my environment no 2), same from here:

https://dynamics.microsoft.com/en-us/dynamics-365-free-trial/

But, choose Marketing

4. Then you will see new environment: "Marketing Trial" will be created in your tenant and you can have Marketing app there.

5. You cannot get more than one Marketing App in the Trial tenant, so what you need to do is you need to uninstall the app to be installed in another environment.

6. Go to the Admin Centre and go to the Dynamics 365 Apps

Power Platform admin center (microsoft.com) then click Manage

7. Then You should see it is installed under Marketing Trial and you need to uninstall it to free up the app.

8. After it has been uninstalled, under the same link when you uninstalled, you will be able to Install it to different organization, it will take some times.

9. And here is the result after you install it to another environment.

Here we go your Marketing app is Ready to Use

*Please note that this may not work in the future.

Hope this helps! Thanks

Join Multiple Tables in Canvas App using Lookup

 Hi all,

So, imagine that you have 2 tables

Table A: "Team Assignment" and Table B: "Player", with Player (Display Name: Player and Schema Name is new_playerid) is the Foreign Key

Now, I want to have gallery in CanvasApp that showing the Information:

Team Name, Player Name, and Date of Birth

I have been trying to find the answer and could not find it because typically if you just use lookup and without match the foreign key which is Player Id in this case, you will not get the correct Date of Birth, instead will just get the "first record" which is in the case is 1-Jul-95 (Donny's)

So, here is the answer:

Put the code in the Items property of the Gallery

AddColumns('Team Assignments', 

"PlayerObject", 

LookUp(Players, Player = 'Team Assignments'[@Player].Player))

With this, you can get all the columns from both tables, if you need just one column, you can just add it in the LookUp formula

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Hope it helps!

New Geospatial Features in Power Apps

Hi all,

Microsoft recently launched the Geospatial Features in Power Apps early this year

https://powerapps.microsoft.com/en-us/blog/announcing-the-general-availability-of-geospatial-features-in-power-apps/

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/geospatial-overview#enable-the-geospatial-features-for-the-environment

Now, you can try it out!