Community Highlights | May & June 2021

[heaher_iTalent]

Community Highlights

Power Platform Communities: Power BI, Power Apps, Power Automate & Power Virtual Agents

Updates:

New Forum! We would like to Welcome the Process Advisor forum board to the Power Automate & Family.

What is Process Advisor?

Process advisor records and analyzes your manual business tasks. It discovers inefficiencies and shows optimization and automation opportunities. For example: in a healthcare facility, you could use the process advisor to record patient check-in procedures. Process advisor automatically produces a process map that visualizes the check-in process. You can see which activities take the longest, how many variations of the check-in process there are, and what variations and actions take the most time. Using this information and the powerful features in the process advisor, you can drive improvements to make a difference for the business. Check out the full post in your community News & Announcements: Power BI, Power Apps, Power Automate, Power Virtual Agents

Time Zone:

To ensure you see your User Group Events in your time zone. Check out how to update your time zone in your community profile.

We encourage community users to ensure that the time zone for your community profile is correct. 

1. Sign in to your community account
2. Click on your avatar
3. In the drop-down menu, go to My Settings

Select the 'Preference' tab, and then 'Preference Options'. 

Choose your time zone and select 'Save'. 

New look in Community Private Messages with threaded messaging

• Threaded view of conversations: Inbox & Sent items
• New design in mobile view
• Multiuser private messages
• Broadcast Messages
• Search within Private Messages 

The inbox is now presented in a threaded view and a streamlined experience:

Toolbar Update:

The Insert Code Sample button can now be seen in the top row of the toolbar. Thank you to the Super Users for this request!

User Groups:

Have you checked out New Microsoft User Groups Experience?

We are super thrilled to announce that Dynamics 365 and Power Platform communities supporting user groups. If you are a leader please check out the links below and request the creation of your group in this new experience. If you are looking to join, give a look to see if your user group has been requested if you are already a member of one. We hope to see many existing user groups being to join this new experience over the next few weeks.

• Power BI User Groups
• Power Apps User Groups
• Power Automate User Groups
• Power Virtual Agents User Groups
• Dynamics 365 User Groups
• For user groups whose focus spans more than one of the above communities, visit Power Platform User Groups

What is a public preview? It is a preview of the experience open to all to test functionality and collect feedback until general availability – Summer 2021.

How to Access User Groups

From Power BI, Power Apps, Power Automate, or Power Virtual Agents communities, you will click the 'Community' dropdown in the top-level navigation and select 'User groups':

From the Dynamics 365 community you will choose 'User Groups' from the header at the top of the page:

Discover User Groups and User Group Events

The user group landing page is called the 'Discover' page and will provide recommended user groups and events. 

If you are looking for a user group, you can either enter a new location in the location field, or select 'See all' for a full listing of user groups, and you will be taken to the 'Group search' page, see below.  

While still on the 'Discover' page, you can sign up for a user group event. You can enter a new location in the location field, select a date or a format (online or in-person) that fits what you are looking for. 

You can also select 'See all' under the results rendered and you will be taken to the Events Search page, see below. 

If you know that you are looking for, a 'Networking' or 'Learning' event, you can scroll to the bottom of the 'Discover' page, and select the one you are looking for. You will be taken to the event search page, already filtered by the type of event chosen. 

Check out more about User Groups: User Group Member Page, Inviting Community Members to a User Group, User Group Events Page, Your Groups PageUser, Group Events, Event Info Page, Search events, Your events in your community.

To get an overview of our community user group experience, check out our support article that is available in each community: 

• Power BI Community User Group Experience
• Power Apps Community User Group Experience
• Power Automate User User Group Experience
• Power Virtual Agents User Group Experience
• Dynamics 365

Check out our Top Super Users & Top Users reaching new levels

 These Top Users are posting, answering questions, kudos, and providing top solutions in their communities.

Top May 2021 Users                                                                           Top May 2021 Super Users

Community	Username	Rank	Community	Username	Rank
Power BI	Jiwhan_Kim	Community Champion	Power BI	amitchandak	Super User IV
Power BI	selimovd	Community Champion	Power BI	Fowmy	Super User IV
Power BI	HashamNiaz	Solution Supplier	Power BI	Greg_Deckler	Super User IV
Power Apps	CNT	Resident Rockstar	Power Apps	RandyHayes	Super User III
Power Apps	Zaphod88	Responsive Resident	Power Apps	WarrenBelz	Super User III
Power Apps	C-Papa	Responsive Resident	Power Apps	PStork1	Dual Super User III
Power Automate	Damobird365	Community Champion	Power Automate	Pstork1	Dual Super User III
Power Automate	jinivthakka	Resident Rockstar	Power Automate	PrasadAthaly	Super User
Power Automate	NiloferA	Resolver IV	Power Automate	Expiscornovus	Super User III
Power Virtual Agents	GRoman	Regular Visitor	Power Virtual Agents	jCook	Super User III
Power Virtual Agents	prufach	Frequent Visitor	Power Virtual Agents	renatoromao	Super User
Power Virtual Agents	neeraja	Frequent Visitor

Top June 2021 Users                                                                           Top June 2021 Super Users

Community	Username	Rank	Community	Username	Rank
Power BI	Jiwhan_Kim	Community Champion	Power BI	amitchandak	Super User IV
Power BI	selimovd	Community Champion	Power BI	Fowmy	Super User IV
Power BI	AlexisOlson	Resident Rockstar	Power BI	parry2k	Super User III
Power Apps	CNT	Resident Rockstar	Power Apps	RandyHayes	Super User III
Power Apps	zmansuri	Memorable Member	Power Apps	WarrenBelz	Super User III
Power Apps	RoryBI	Resident Rockstar	Power Apps	Pstork1	Dual Super User III
Power Automate	Damobird365	Community Champion	Power Automate	Pstork1	Dual Super User III
Power Automate	yoshihirok	Memorable Member	Power Automate	Expiscornovus	Super User III
Power Automate	jinivthakkar	Resident Rockstar	Power Automate	ScottShearer	Super User III
Power Virtual Agents	GRoman	Regular Visitor	Power Virtual Agents	jCook	Super User III
Power Virtual Agents	prufach	Frequent Visitor	Power Virtual Agents	renatoromao	Super User
Power Virtual Agents	neeraja	Frequent Visitor

News & Announcements Board: 

Make sure you are always up to date with the latest community happenings, in the News & Announcements board in each community: Power BI, Power Apps, Power Automate & Power Virtual Agents.  

You can also subscribe to the board so you do not miss anything subscribing is easy check out our support article, Subscriptions & Notifications in Using the Community!  Power BI, Power Apps, Power Automate & Power Virtual Agents

Community Blogs

Each month our very own community blog authors publish some fantastic content to our community blog. A huge shoutout to these folks for taking the time to share their knowledge and expertise with the community!  Power BI Community Blog, Power Apps Community Blog, Power Automate Community Blog, Power Virtual Agents Community Blog

Thank you to our blog authors for writing some amazing blogs:

Power BI Community Blog: 

Automatically update data according to the date in the file name | Author: Janey Guo by @V-pazhen-msft 

Why is it sometimes not possible to select the exact number in the what-if parameter? by @selimovd

Marketing channels performance analysis in Power BI by @Djordje_M

Power BI Challenge 13 Wrap Up: Acing Documentation by @EnterpriseDNA 

Hide a Column Header on a Table in Power BI by @PriscillaCamp

Date Transformation Issue in Power BI Service by @Anonymous 

Exponential Moving Average in Power Query (EMA) by @Fowmy

External Tools In Power BI Desktop - Tutorials For Beginners by @EnterpriseDNA 

Introduction to AI Insights in Power BI Desktop by @PriscillaCamp

Lookup multiple columns in Power Query  by @ERD

Several factors influencing Drill through feature in Power BI  by @v-yiruan-msft

Power BI Dev Camp: June 24th | 11a PDT- Developing with the App-Owns-Data Starter Kit by @TedPattiso...

Fully customizable reports by @TimoRiikonen

Power BI Basics: Types of Tables In Power BI & Their Distinctions by @EnterpriseDNA 

Modern Visual Tooltip in Power BI  by @Pragati11

[DAX] Visualize last N months picking only one from filter context by @ibarrau

How to extract values of date/currency amount from text strings in Power query  by @V-lianl-msft 

Tips & Tricks To Build The Best Map Visualizations In Power BI  by @EnterpriseDNA 

Modern Visual Tooltip in Power BI  by @Pragati11

Circular Dependency between Calculated Columns in a Table in DAX by @AntrikshSharma

How to fuzzy match the dirty data and horizontal display the corresponding table by @v-lili6-msft 

Creating & Utilizing An Extended Date Table In Power BI – New & Effective Approach by @EnterpriseDNA 

USERNAME() v/s USERPRINCIPALNAME() in RLS for Power BI Embedded scenarios - When to use what? by @monaraya 

Power BI Dev Camp | Teaches Advanced Data Modeling - May 27th at 11a PDT by @TedPattison 

Creating a Visual Calendar in Power BI by @dedelman_clng 

Json Transformations by @v-lionel-msft

How To Create Superior Navigation Experience For Power BI Reports by @EnterpriseDNA 

Query Folding in PowerBI by @Kumail

POWER BI >> HOW TO FORMAT ALL DAX MEASURE AT ONCE by @Anonymous

Line chart with range of values in Power BI by @v-yiruan-msft

High Quality Power BI Reports Using Custom Visuals  by @EnterpriseDNA 

Power BI Challenge 13 – Acing Your Documentation by @EnterpriseDNA 

Refresh error: The xxxx column does not exist in the rowset by @V-lianl-msft

Split Amount Across Months Using Power Query  by @Fowmy 

Importance of efficient CRM reporting - Power BI Salesforce Dashboard by @Djordje_M

How to merge different rows with the same attribute into one row  by @v-yiruan-msft 

Creating Value Dynamic Formatting using Calculation Groups by @pade 

Power Apps Community Blog: 

Power Apps – One app platform to rule them all  by @Bridgeall

Creating Azure Functions, Custom Connectors and using them inside of Power apps by @chass

Power Automate Community Blog: 

Back to Basics #1: How to set up a Dynamics 365 / Power platform Trials by @codevenkat

Alterative to Disable Actions in Power Automate  by @PrasadAthalye

Power Automate Desktop - How to Read Element HTML by @PrasadAthalye

Power Virtual Agents Community Blog: 

How to use mark down to format a table for the bot response-for-the-bot-response/ba-p/1190942  by Expiscornovus

Community Support

As your community management team, we welcome all questions related to your Power Platform Community experience. If you need help with something related to your community profile, please head over to the "Community Support" category where you can submit a support request form and be guided through the steps to accomplish administrative tasks like changing your email address or your username.  We are here to assist you with any questions you may have about the Power Platform Communities. 

Check out the Community Support Areas: Power BI, Power Apps, Power Automate, Power Virtual Agents

Did you find what you were looking for?  If not, please visit our Community Feedback board in each community and make a post.

Community Feedback boards: Power BI, Power Apps, Power Automate, Power Virtual Agents.

[Syndicate_Admin]

Thank you @heaher_italent for the shout out, will continue to share my learnings !