Power Platform Developers Weekly – Issue #12

Want to get newsletter to your mailbox? Subscribe here

---

Don’t miss the opportunity to pick new skills or brush up old ones; this Saturday Powerthon 365 Saturday is hosting Power Platform Developer online event. It is a 2-day event on 6th & 7th June from 6:00 AM to 6:00 PM UTC/GMT. Learn how to build things with MVPs and Community Leaders. Register for the event.

Missed Power Apps Community call; here is the recording.

If you like this newsletter share it on social media and forward it to your friends and ask them to sign up here.

– Danish N.

---

🥇 Cover Story

DirectQuery CDS from Power BI | crm chart guy — crmchartguy.com

Now, at the most recent Microsoft Business Applications Summit, a new method was announced that I was finally able to try out. The method is using the new…

👍 Power Platform Updates

Redirect to Login page always after logout in Dynamics 365 Portal — www.inogic.com

In this blog, we will see how we can navigate to login page after once we logout from any page in Microsoft Portal.

Dataflows in CDS — www.agarwalritika.com

In this post, I will walk through the steps required to build a Dataflow in CDS to sync data between an external datasource and CDS.

Omnichannel for Customer Service – Agent Scripts & Macros (and slugs) — neilparkhurst.com

Omnichannel for customer service contains a number of features to help improve agent productivity. In this post I will explore two of these – Agent scripts and Macros.

💎 Common Data Service

Nested expansion using the $expand query option via the Web API by example — community.dynamics.com

A question that I keep getting is, “Can I perform nested queries using $expand query option with the Dynamics 365 Web API?”. The answer is, yes.

Get User’s last logon time in Dynamics 365 – Nishant Rana’s Weblog — nishantrana.me

Nishant Rana looks into how to get user’s last logon time using FetchXml.

How to pass formContext and XRM to your html webresource – Dancing with CRM — www.dancingwithcrm.com

Learn about supported way to pass formContext and XRM to your html webresource

🏋️‍♂️ PowerApps & Power Automate

Setting a lookup field to blank – Hardit Bhatia: The Power Addict — thepoweraddict.com

After spending close to 2 hours trying to figure out why code wasn’t setting a lookup field in CDS to blank. Let’s look who the culprit was..

Implementing Exit app, Logout and Confirm Exit features in a Canvas Power App | D365 Demystified — d365demystified.com
Check how you can put exit, confirm before exit and logout features in your Canvas Power Apps.

🔨 Tools & Components

Using Data Spawner component (SSIS) to generate sample data in Dynamics 365 — nishantrana.me

Data Spawner component is part of KingswaySoft’s SSIS Productivity Pack.

Undo History — appsource.microsoft.com
Undo changes / mistakes with a single click. Tracks all changes

Simple Notification | PCF Gallery — pcf.gallery

A control to display a notification or a helpful message to the user in a section. This should avoid to create static web resource to display information.

🔊 Podcasts

XrmToolCast: Developer Frameworks on Projects with Scott Durow Part 2 — xrmtoolcast.libsyn.com

In this episode, Jonas puts the call out for help with using frameworks on projects, so we call in Scott Durow to discuss. This is part 2 of a 2 part episode.

🎥 Videos

🐤 Tweets of the week

#PowerApps #LifeHacks #2 🔥

Want a quick visual of the colors in your theme? Store them in a variable then type varColors🎨in the formula bar.

Set(varColors,
{
P1: RGBA(224,57,18,1),
S1: RGBA(220, 153, 153, 1)
}
)

What's next @rezadorrani? @HoustonPowerUG pic.twitter.com/9jCVKQb95k

— Matthew Devaney (@mattbdevaney) May 25, 2020

🤩 Thanks for reading

How did you like this issue? Was it useful and byte-sized? Are there certain kinds of content you’d like to see here? Let me know what you think on survey.