Category: PowerApps

Plot Multiple Map Points In Power Apps (Canvas Apps) with Dynamic Filters

Hi Everyone

In this vlog we will see how to see multiple points/pushpins on a map in canvas app. As always, this is a no code solution and fairly basic.

I have came across this requirement so many times in Dynamics 365 for e.g. show all customers on a map or contacts on a map or even appointments on a map. Many solutions are available for Dynamics 365 CE including add ons like Maplytics. But for canvas app, following issues persists:

  • No map components
  • Static bing/google maps can be inserted by inserting an image and then providing URL
  • Bing or Google maps API is required
  • Hard code latitude and longitude
  • If you want to show more than one push pin, you need to hard code all coordinates
  • You can’t apply dynamic filters on your maps

To me all of the above are not easy to use solution and that’s why I decided to look for something which all our #nocodemonkeys can use. This can be the fastest way you can plot all your customers on a map within canvas apps.

Prerequisites:

  • Access to Power Apps
  • Access to Power BI (Desktop and Web)
  • Super Basic Knowledge of how to create a chart/report in Power BI
  • Basic understanding of Power Apps formulas
  • Entity (accounts/contacts/appointments) must have Latitude and Longitude filled (otherwise it won’t be shown on maps

Note: You can get latitude and longitude by create a flow in Power Automate

Step 1-7 for Power BI and Step 8-12 Power Apps

Step 1: Go to your Power BI Desktop>>Create a connection>>Get data (e.g. Accounts)

Step 2: Once your data is loaded>>click on report icon and then add the visualisation type as shown below:

Step 3: Add data fields

Step 4: Save your Power BI report by clicking on the disk button on top left

Step 5: Login to Power BI web https://app.powerbi.com/

Step 6: Click on ‘Workspace’ in the left navigation and then click reports (this is where you can find the report you created in above steps)

Step 7: Click on the report to open and then click pin visual

Step 8: Login to Power Apps https://make.powerapps.com/ and pick your existing app or create a new canvas app

Step 9: Click Insert then ‘Power BI tile’

Step 10: Select Workspace, Dashboard and Tile

Dynamic Filtering- Step 11 & 12

Step 11: Apply dynamic filtering by adding new components like Text Input or Drop Downs. In my case, I have two drop downs and one text input; names below:

StateDropDown- With 5 values (you can have any values here)

CityDropDown-With 5 values (you can have any values here)

txtPostCode- Text input for ZIP/Postal Code

Step 12: Update the ‘TileURL’ of Power BI tile. Use the following sub-steps based on how many filters you need as it can go to Nth level (I am only showing three)

12a. One field filter

“Power BI TileURL” & If(!IsBlank(txtPostCode.Text),
“&$filter=accounts/address1_postalcode eq ‘” & txtPostCode.Text & “‘”)

12b. Two fields filter

“Power BI TileURL” & If(!IsBlank(txtPostCode.Text),
“&$filter=accounts/address1_postalcode eq ‘” & txtPostCode.Text & “‘”,
!IsBlank(CityDropdown.SelectedText.Value),
“&$filter=accounts/address1_city eq ‘” & CityDropdown.SelectedText.Value & “‘”)

12c. Three fields filter

https://app.powerbi.com/embed?dashboardId=ed06a838-8b0f-4445-a582-1890699df2d3&tileId=401efbc1-2194-4807-a07e-7e89567e49ce&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLUFVU1RSQUxJQS1FQVNULUEtUFJJTUFSWS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCJ9” & If(
!IsBlank(txtPostCode.Text),
“&$filter=accounts/address1_postalcode eq ‘” & txtPostCode.Text & “‘”,
!IsBlank(CityDropdown.SelectedText.Value),
“&$filter=accounts/address1_city eq ‘” & CityDropdown.SelectedText.Value & “‘”,
!IsBlank(StateDropdown.SelectedText.Value),
“&$filter=accounts/address1_stateorprovince eq ‘” & StateDropdown.SelectedText.Value & “‘”
)

Note: Screenshot below for better understanding

Result after dynamic filters

Video here:

Hope it helps!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

Sharing my MVP Award with you!

Hi Everyone

A huge thank you to all for supporting me by watching my videos, subscribing to my channel and blog. it couldn’t have been possible without your support and that’s why I decided to share my MVP award with you by unboxing it together.

I received the notification of my award via email on 1st Jan 2020 and I received the actual award kit itself on 20th Jan 2020. Since I wanted to unbox it together with you, I thought I will wait until I can make a video. It was hard to see the box but not be able to open it but I was happy that I am sharing it with you guys.

I shared the news on Linkedin and received 35000+ views on my post and that’s just amazing for me. Follow me on linkedin, twitter and if you’ve not subscribed to my channel, do it now. 🙂

Unboxing video here:

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

Using Timer Control In PowerApps (with problem scenarios and Business use cases)

Hello Readers and Viewers

This blog/video is part of my quick tip series. We are going to look at how we can force a screen to be visible to a user irrespective of the transition, in other words delay screen transition.

Skip to the video, if you don’t want to read

Example Problem 1: if we want to Navigate to more than one screen back to back only the last screen mentioned in navigate formula is visible to the user; that means one navigate screen is skipped. for e.g. look at the formula below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade);Navigate(lstMembers)

If you apply the above formula to your Power Apps, users will always end up seeing “Navigate(lstMembers)” and the success screen is skipped.

Example Problem 2: if we remove the last bit of the formula and have only one ‘navigate’ as shown below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade)

if you apply the above formula, users will have to touch on the success screen somewhere to be able to see any other screen. (assuming success button in below screen will have navigate formula)

b1

Solution to both the example problems: First of all remove the last navigate from the formula and only have one navigate, shown below:

Select(Parent);SubmitForm(checkinform_1);ResetForm(checkinform_1);Navigate(Success,ScreenTransition.Fade)

Note: I am not saying you must use the exact same formula as above, you need to change the formula as per your need but only have one navigate in the formula.

Now on your success screen add a timer by going to Insert>>Input>>Timer

b2.JPG

Set AutoStart to true

Set the duration of the timer by clicking on the timer on screen (Completely on your requirements, for how long you want a user to see a screen)

1000=1 second 5000=5 seconds 30000=30 seconds

Set OnSelect to false

b3b4b5

Set the second navigation on your ‘TimerEnd’ property

b6

Now hide the timer, so your users can’t see it

b7

And all done, your users will now be navigated to the screen of choice without having to click anywhere.

Business Use Case: You want your users to see a success screen for ‘n’ seconds and then auto-redirect to a list or another form.

Video here:

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

The Master is here for the Brisbane PowerApps and Flow User Group

Hello QLDers

I am really excited to give you a heads-up that in next month’s User Group, we will have the master himself presenting.

Did you guess it yet? it’s Charles Sterling 🙂

Linkedin here

Twitter here

Following is what he’s going to talk about (Still in discussion):

  1. PowerApps AI Builder
  2. Integrating PowerApps and Power BI

For more details visit the power users website here.

We will publish the agenda and venue soon on ‘Brisbane PowerApps & Flow User Group‘ website and Meetup Group

Make sure to RSVP as soon as you can because seats would be limited.

If you’re not from QLD and visiting Brisbane towards the end of November 2019, make sure to join the group and let us know if you’re interested in attending.

Thanks for your attention.

Let’s keep sharing!

Mocking Up Genius Bar’s Create Your Style App with PowerApps

Hi Readers and Viewers

This is a short video where I am trying to mockup genius bar’s ‘Create your style’ app/feature. This can help you if you sell product bundles which work together as a bundle only for e,g, tablet and keyboard.

Watch the video here:

Let me know your thoughts!

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!

PowerApps for Business Users & Consultants: Episode 8- Infusing AI in your PowerApps

Hi Readers and Viewers

With this episode, I am concluding my ‘PowerApps for Business Users and Consultants’ series.

In this episode, we are going to look at using AI builder components in our PowerApps.

AI Builder currently has following components in preview:

  1. Business Card Reader
  2. Form Processor
  3. Text Classification
  4. Object Detection
  5. Prediction

We have focussed only on the following two and it’s business use cases:

  1. Business Card Reader
  2. Form Processor

Video here:

We have also talked about, what to do when your trial for AI expires:

Purchase/Extend

What error you see?

We have also talked about where to learn advanced PowerApps while I am thinking of my next series:

Shane Young’s Channel 

Brian Knight from Pragmatic

Thank you so much for all the love and support. I will be back with a new series soon.

Subscribe to my YT channel and follow my blog.

Hope it helps!

Let’s keep sharing!

PowerApps & Flow User Group App for Leaders, Hosts, Organisers and Coordinators

Hello Readers and Viewers

As User Group organisers, it becomes difficult for us to track the attendance of participants mostly due to the format of the meeting. In our last week’s UG we were prepared to break the ice and created an app to check in attendees.

Following is what you can do with the app:

  1. Register attendees as members
  2. Update member details
  3. Check In attendees
  4. Draw Raffle (if and when it’s available)

What can you get out of it:

  1. Track the attendance of your members
  2. If members are not regular, send them a survey for what they want to see
  3. Send them a FormsPro survey to get feedback
  4. Keep member details up to date
  5. Instead of drawing raffle the conventional way, use PowerApps

Screens:

Home

IMG_0279

Register Participant

IMG_0281

Update Details and Check In

IMG_0282

Note: Check In form is hidden, so members don’t have to fill in date, UG and their name again

Members List

IMG_0280

Draw Raffle

IMG_0283

Note: Shuffle formula and collection is used for Raffle draw

Data Source: OneDrive (Excel Web)

Tables used: Registered Members and Checked In Members to draw raffle

If you’re a User Group leader and want to use this app; you don’t really have to make any changes except for the connection and start using it. I have uploaded it on github. More instructions on there:

https://github.com/diyd365/UserGroupApp

Watch the youtube demo here:

Subscribe to my channel and follow my blog.

Thanks!

Let’s keep sharing!