Power Apps Map Control, integration with 3rd party APIs

Подписаться 13 тыс.

Просмотров 6 тыс.

50% 1

This video will show you how to bring data from external sources like the Aldi, M&S, and Starbucks store locator APIs, directly into your Power App using the HTTP action and Power Automate. I'll show you how to easily query your nearest store based on geolocation data and display the results on a map control in Power Apps, all while explaining the process step-by-step. Using the Bing Maps connector, I'll demonstrate how to retrieve longitude and latitude based on a city location and pass that data into Power Automate. I'll then show you how to use a "Select" function to repurpose the data and join it with a Union. Finally, we'll show you how to create a schema and pass the data back to your Power App, allowing you to use the data in a collection and configure the Power App Map control for easy filtering and display of results. Whether you're a beginner or an experienced Power App user, this video has something for everyone.
Open APIs at the time of making the video are below, but more are available by searching the web:
stores.aldi.co.uk/store-finde...
api.marksandspencer.com/v1/st...
www.starbucks.co.uk/api/v1/st...
00:00 Intro
01:24 Query API via Power Automate
05:06 Repurpose data using a select
11:56 Overview of Select and Expressions
14:45 Power Apps Trigger
17:23 Test flow via manual run
18:34 Building a Power App
20:04 Using the bing connector and flow
23:03 Quick fix of data / expressions
24:12 Configure a Map Control
25:45 Adding a combo box using Distinct
28:21 Outtro
Don't forget to check out my other videos, like and subscribe! Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Наука

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 35

Год назад

Great POC with HTTP API queries. Liked it 👍before just watched it, since I heard the magic word "repurpose" and I knew it will worth it. Thanks for sharing, excellent job Damien!

@DamoBird365 Год назад

Cheers Kristof, I love a challenging array 😉

@ricardobunge5957 Год назад

Brilliant as always, Damien! As well, a great lesson on stepping through and parsing JSON. Thanks very much!

@DamoBird365 Год назад

Cheers Richard, I hope you can make use of it somewhere.

@kingsleyudeagha Год назад

You are the best to ever do, Damien.

@DamoBird365 Год назад

Thank you Kingsley 👍

@Amritasthegreatindiantaste Месяц назад

Damm Good ! It helped me Lot . Thanks

@ankhbilegts3162 Год назад

What a cool video. Thank you so much

@DamoBird365 Год назад

Thank you Ankhbileg, I hope it was useful. 👍

@jasonmcandrew5661 Год назад

Great video Damien! It was interesting to see the HTTP response instead of using Respond to Power Apps. I've been building a similar app based on our customer and project locations from dataverse.

@DamoBird365 Год назад

Did you use ParseJson() in PowerApps? It’s interesting to hear about other use cases. Thanks.

@jasonmcandrew5661 Год назад

@@DamoBird365 In my scenario I used the dataverse connector directly in PowerApps to retrieve the data and load into collections. I'm yet to try the ParseJson() function in Power Apps, up to now I've always done that sort of thing in Power Automate. Cheers.

@DamoBird365 Год назад

@@jasonmcandrew5661 got you. Data was already in Dataverse rather than querying from an API? Either way, sounds like an interesting project you’ve got there.

@michielsnoek2937 Год назад

Absolute top!

@DamoBird365 Год назад

Thank you Michiel, I really enjoyed this one.

@franknielsen3219 Год назад

Brilliant, just brilliant 👌👌

@DamoBird365 Год назад

Thanks Frank.

@TinyMagiq Год назад

Lovely content. thanks for sharing.

@DamoBird365 Год назад

Thanks for your email also 🙏 I’ll be in touch.

@davidadams421 Год назад

Very interesting wrapped in a blanket of outstanding. I've never really had an intuitive understanding of parsing json in the expression editor ... until now! The PowerApps function construction was over my head but I could at least follow what you were doing. I wonder if you could avoid the HTTP Premium connector by using Azure Logic Apps? They are 'consumption' based but cost tiny fractions of pennies to run (I assume there is a connector for them).

@DamoBird365 Год назад

Thanks David. Definitely a good use case for Logic Apps 👍 good shout. learn.microsoft.com/en-us/azure/connectors/connectors-native-http

@davidadams421 Год назад

@@DamoBird365 I've used them before when calling APIs they don't already have a connector for. Useful also because setting up OAuth is _relatively_ simple for connecting to APIs that require authentication.

@AlexHoSuzhou Год назад

Seems collection couldn't be create after click "Search" button in Power Apps, only get Value, True in colShops collection

@DamoBird365 Год назад

Hi Alex, have you created a schema for the response action? I think that’s missing. Please share your final solution online. I would love to see it.

@AlexHoSuzhou Год назад

@@DamoBird365 After I move the canvas App are flow to solution and re-add the flow in App, the collection is suddenly working now, colShops are created as expected, thanks for your quick response.

@DamoBird365 Год назад

Fantastic 👍 glad you’ve had success. 😍

@justinchau70 Год назад

Amazing video! Howd you get the racoon by the way?

@DamoBird365 Год назад

That’s Bit the UK Developer mascot. I won it for a challenge I undertook. Worth watching out for the cloud skill challenges.

@geralddahl9159 Год назад

Any thoughts/pointers RE api’s requiring oauth authentication? (Google contacts etc.) Thank you.

@DamoBird365 Год назад

It crossed my mind loads when recording this but I am trying to think of an interesting use case. A custom connector would be one way to go. Or possibly APIM. You could do it via the HTTP action but it would be a pain to manage.

@geralddahl9159 Год назад

@DamoBird365 yes, I met a person online very skilled at working her way through all this and she was certainly busy as a result. Take care, hope your next stop at Starbucks is enjoyable.

@davidadams421 Год назад

@@DamoBird365 Maybe an 'example' use case, not sure if it is an 'interesting' one, though! I used an authenticated API within an Azure Logic Apps workflow to create a SharePoint Document Set when my CRM stage entered 'Contract Won'. It's just something I grew tired of doing manually. The trigger was an authenticated HTTP POST request (+JSON payload) to an Azure Logic App endpoint using Zoho CRM's 'Notify' API. As there is no 'Create document set' action, I had to manually craft the authenticated HTTP request to SharePoint using the document set's content type. The beauty of the solution is that the document set is then created using my standard sales templates and pre-configured with all the necessary metadata from my CRM (customer details etc). Inserting document metadata into office documents is relatively straightforward so my sales documents (T&C's, Contract etc) basically made themselves on 'Contract Won' CRM stage transition. Interesting? Not sure. Hard? Bloody hell, yes it was! I am not a developer - took me months of blood, sweat and tears! But it was an interesting challenge.

@DamoBird365 Год назад

@@davidadams421 it’s good to find a challenge and crack it 👍 have you shared the idea anywhere? If you’ve needed to create something, others would appreciate it. Only if you want to of course pnp.github.io/sharing-is-caring/

@davidadams421 Год назад

@@DamoBird365 Ha! I've never thought anything I have ever done as good enough to share! I just 'muddle through' as best I can.