@@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.
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.
@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.
@@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.
@@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/
@@DamoBird365 Ha! I've never thought anything I have ever done as good enough to share! I just 'muddle through' as best I can.
Год назад+2
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!
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 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.
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 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.
@@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.
Damm Good ! It helped me Lot . Thanks
Seems collection couldn't be create after click "Search" button in Power Apps, only get Value, True in colShops collection
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.
@@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.
Fantastic 👍 glad you’ve had success. 😍
Any thoughts/pointers RE api’s requiring oauth authentication? (Google contacts etc.) Thank you.
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.
@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.
@@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.
@@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/
@@DamoBird365 Ha! I've never thought anything I have ever done as good enough to share! I just 'muddle through' as best I can.
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!
Cheers Kristof, I love a challenging array 😉
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).
Thanks David. Definitely a good use case for Logic Apps 👍 good shout. learn.microsoft.com/en-us/azure/connectors/connectors-native-http
@@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.
Amazing video! Howd you get the racoon by the way?
That’s Bit the UK Developer mascot. I won it for a challenge I undertook. Worth watching out for the cloud skill challenges.
What a cool video. Thank you so much
Thank you Ankhbileg, I hope it was useful. 👍
Brilliant as always, Damien! As well, a great lesson on stepping through and parsing JSON. Thanks very much!
Cheers Richard, I hope you can make use of it somewhere.
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.
Did you use ParseJson() in PowerApps? It’s interesting to hear about other use cases. Thanks.
@@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.
@@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.
Brilliant, just brilliant 👌👌
Thanks Frank.
Lovely content. thanks for sharing.
Thanks for your email also 🙏 I’ll be in touch.
You are the best to ever do, Damien.
Thank you Kingsley 👍
Absolute top!
Thank you Michiel, I really enjoyed this one.