This is excellent, thank you! Please continue digging deeper in to API's, there is just so much you can achieve by integrating with other systems.

@ShanesCows

3 жыл бұрын

Thanks, will do!

You're my light. I needed to connect to a database with rest api and synchronize the data into a SP list. Works like a charm now. Thansk a lot

@ShanesCows

8 ай бұрын

Excellent! Have a great day!

Can’t tell you how much I appreciate this video. Dealing with arrays as a json result have been very challenging. There aren’t any videos that I could find that walked through like you did. Thanks again

@ShanesCows

3 жыл бұрын

Awesome. Glad it helped. 🐶

Awesome, i have used this to run API for my Bulk SMS account, working so well, Thank you Shane

@ShanesCows

3 жыл бұрын

Very cool. 😎

Fantastic Shane, a great video. I'm no developer but you show how things can be done that won't scare people away from giving it a go!

@ShanesCows

3 жыл бұрын

Awesome, that is my goal. I am not a developer either so always fun to learn together.

Thanks Shane, really excellent breakdown and walk through.

@ShanesCows

3 жыл бұрын

My pleasure!

Awesome video. Mind blowing!!!!! Power automate has a setting for preview. This will change the way you write your expressions in flow. Its much more user-friendly when troubleshooting give it a try. And keep the videos coming

Hi Shane, just wanna say thanks for the awesome video. It is really fun to watch probably because the way you talk and most importantly it really helps for newbie like me.

@ShanesCows

2 жыл бұрын

Glad to help. 😀

Thank you so much for adding hilarious personality to educational content. Well done!

@ShanesCows

2 жыл бұрын

Thanks BJ. I know this stuff is boring so I do my best to bring a touch of fun to it.

Thank you! Shane. always coming up with great stuff.

@ShanesCows

3 жыл бұрын

Thanks, you are very kind.

@davig5184

3 жыл бұрын

@@ShanesCows Hey Shane, got "error -2002" "request timeout" any advise? Thank you!

Really fascinating video. Amazing explanation. Thanks Shane

@ShanesCows

7 ай бұрын

Glad it was helpful!

Fun demo! Yes, let's keep digging deeper (custom connectors, Azure API Management, all things external integration).

@ShanesCows

3 жыл бұрын

More to come! I enjoyed the API stuff.

Where is the love button on KZread?? Great content!!! 👍

@ShanesCows

2 жыл бұрын

Wow, thank you!

Thank you, Thank you Shane this is greatly helpful even for a former developer !!

@ShanesCows

2 жыл бұрын

Awesome!

Finally it's here...Thank you so much Shane for creating this video...😁😊🎉

@ShanesCows

3 жыл бұрын

Happy to help Devang

Great Again! Here to learn how how to post a SharePoint list to an external system using RestAPI and JSON upon list change.

Exactly what I've been looking for to increase automation on our video production system. I just wish it wasn't Premium! Great demo as usual.

@ShanesCows

3 жыл бұрын

Thanks. Premium isn't ideal but one $15 license should cover you for all of hte flows you need for you.

Awesome video as usual - thanks a lot. Proud to be Shane's follower:). Interesting to explore alternative of doing Rest API call completely in PowerApp via custom connector (BTW will it save few bucks)? Or is Power Automate just "user friendlier" :)? Shane, please keep coming good stuff, especially all things integrations with external systems.

@ShanesCows

2 жыл бұрын

Will do. Custom connector would be easier but it does change licensing. 😎

This awesome, thank you so much for your time!

@ShanesCows

Жыл бұрын

My pleasure!

this is awesome, when I get moved into my new house, I will DEFINITELY be re-watching this video. (also: FIRST)

@ShanesCows

3 жыл бұрын

Wes you are the best. Hope all is well and congrats on the new place.

Awesome...! I'm using http trigger and collecting machine data to sharepoint and BI. Whereas almsot breaking my head for http action. It is very helpful. Thanks for the rich video...!

@ShanesCows

3 жыл бұрын

You are very welcome. Glad it had lots of little tips to help.

love it "kinda nerdy......but not super scary"

@ShanesCows

3 жыл бұрын

🤓😎

Great one thanks!

It’s awesome and I’m looking forward to watching it 😄

@ShanesCows

3 жыл бұрын

I hope you enjoy it. The video was a lot of fun.

Hi Shane! Great inspiration! I need o use flow to control IOs within the same network that my phone is. Should I use different connector? I want to avoid to use external IP and access due to security reasons...

Hi Shane, great video. Do you have a video that gets into details on how you adjust the dimmer? I bought the TP-Link HS220 device and installed it. I can turn it on or off but would love to adjust dimmer brightness on it as well. Would really appreciate if you could make a video on it or explain it in detail.

@ShanesCows

6 ай бұрын

Manny I haven't messed with this stuff in a long while. But here is what I tell you to try. Try using this with hard coded values for everything. Don't try to automate just use this JSOn, strip out all of the dynamic content and see if you can set the brightness to 25 and 100 manually. If you can then start to try working on making it dynamic. Hope this helps. { "method": "passthrough", "params": { "deviceId": "@{body('Parse_JSON_2')?['result']?['deviceList']?[0]?['deviceId']}", "requestData": { "system": { "set_relay_state": { "state": @{If(equals(outputs('Compose_to_Check_if_Brightness_is_over_100'),0),false,triggerBody()?['OnOrOff'])} } }, "smartlife.iot.dimmer": { "set_brightness": { "brightness": @{outputs('Compose_to_Check_if_Brightness_is_over_100')} } } }, "token": "@{body('Parse_JSON')?['result']?['token']}" } }

I have to tag this and come back to it later By the way thanks from down under

@ShanesCows

3 жыл бұрын

Glad to help. This is a fun video for sure.

Hi Shane, great video. IoT is really cool and I would appriciate if you can show more videos about IoT e.g. sensors temperature, humidity, motion sensor

@ShanesCows

3 жыл бұрын

If I get my hands on any cool stuff like that I will for sure. :) Do you have recommendations on cheap sensors with APIs?

@nuinhuin7325

3 жыл бұрын

@@ShanesCows i have a scenario which might be ok for you. Light is off. Create request. Status waiting for approval. Light is yellow. Request is approved. Light is green. Rejected is red. Request is closed. Light is off. Then start new request and light goes on again.

@nuinhuin7325

3 жыл бұрын

@@ShanesCows Philips Hue light

Thank you Shane!

@ShanesCows

3 жыл бұрын

Happy to help John.

Great video, how about Patch Method to update?

@ShanesCows

2 ай бұрын

If you know the API but are just struggling with syntax I would ask Copilot or ChatGPT. Usually with Patch they have more complicated headers, might be something to look for.

Any experience using Token's in the header vs. the body? Working on an integration with Paylocity receiving one of their webhook notifications. Would love your thoughts.

Wow, really cool, this would have taken hours or days to do with another technology. Amazing, thank you. I'm wandering if it's possible to right commercial app with this...

@ShanesCows

Жыл бұрын

Not today. Everyone who uses the app has to have an account.

Thank you, your article is very good you can show me? how to split multiple threads to call API at 1 time

@ShanesCows

Жыл бұрын

In your flow you can do parallel branches. I don't know if I have a video on it but that will let you run things in parallel.

Hello Shane, thanks for this amazing video. Is there any available way to access Kasa spot KC105 and display its live recording in powerapps?

@ShanesCows

2 жыл бұрын

I don’t know. I don’t have one of those to play with. 😑

What was the authentication used in HTTP trigger

why you are so good at tutoring?🙃

Thank you!

@ShanesCows

3 жыл бұрын

You bet! This one was very fun for me to learn about.

Thanks for sharing. Do we have alternate option if we dont have Premium capacity. I am looking to use API call to add Item details to a Sharepoint List. Any suggestions for that? Thank you

@ShanesCows

8 ай бұрын

I replied to your other comment. Using HTTP action with SharePoint is not premium.

Thanks Shane

@ShanesCows

3 жыл бұрын

You are welcome Sundra. Have a great day.

una consulta, es posible consumir apis que tiene formatos de xml tanto de envio y respuesta ???

I am wondering if you can do a video on how to call Power BI REST API from Power Automate, like get all reports in a workspace

@ShanesCows

2 жыл бұрын

Interesting idea. 😎

I have a flow which suddenly stopped working but if make copy of it that works whereas original flow fails in http action with 403 Forbidden. Can you please suggest what else I can check. Checked Firewall and there are no issues with it or API.

Hello Shane, Do you know if the payload/protocol used to activate and deactivate the device is it still working? I just bought a pair of TP link devices, and I am able to get the list of devices and their IDs, but when I try to use the paiload to activate or deactivate, I always get error_code -20571, msg “Device is offline”. But from the official app installed on my cellphone i can turn them on and off without a problem

The lord of the rings comment made me like and subscribe xD

@ShanesCows

Жыл бұрын

I always love slipping in some small movie/tv reference 😍

Great, please asd a video and store iot data on dataverse to display it into powerapps….

@ShanesCows

Жыл бұрын

Noted. Thanks

This is brilliant - can you please do a video about getting a Twilio message and writing it back to Sharepoint? Also can you do a video about Tesla API?

@ShanesCows

3 жыл бұрын

The Tesla API needs to be done. :) Twilio I will ponder on. I haven't used it much.

@fr.minabarsoum8528

3 жыл бұрын

@@ShanesCows I did the Twilio but the second I connect to Sharepoint it doesn't work. I believe because the connection header for the Twilio is using content-type: application/x-www-form-urlencoded but the sharepoint one using probably something else

Can we get the 3rd part of responsive controls :) thanks Shane!

@ShanesCows

3 жыл бұрын

Fair request. I do need to dig deeper on those again. It is on the list, just to find the motivation now.

@Eb_Games

3 жыл бұрын

@@ShanesCows you the man !

I wanted to integrate my sharepoint with adp and was wondering if i can use adps token api and paste it in for the sharepoint action of send an http request and put the site address of adp?

@ShanesCows

Жыл бұрын

Nope, you will have to use the HTTP action.

@mrwhammer

Жыл бұрын

@@ShanesCows is it a premium feature to use or no

I have the KASA Power Strip HS300 and I would love to be able to control each of the 6 individual outlets! I tried to increment the device 0-6 but no joy!

@ShanesCows

3 жыл бұрын

I don't have one to play with. I was curious and did some poking. I think here is at least some clues as to where you might find it. github.com/python-kasa/python-kasa/issues/64 I think there is some kind of "child_num": 6 that you need to use.

@MarkMcQ

3 жыл бұрын

@@ShanesCows I appreciate you taking the time to reply. I also reached out to Joshua who replied. Joshua Tzucker 6:27 PM (23 minutes ago) to me Hi Mark, No bother at all; always happy to help when I can. I have a few different posts and code snippets floating around the web related to Kasa - is this in regards to my Google Apps Script wrapper? Or cheat sheet? Regardless, although I don't own a power strip to test with, looking through some open-source repos and issue threads, I think I understand enough to provide an answer. It looks like the power strips use a combination of two IDs - the device ID, which corresponds to the entire strip, and a plug id / child id, which corresponds to each individual plug on the outlet. To turn individual plugs on and off, you need to pass both IDs, with the plug IDs pass through a special payload object under `requestData.context.child_ids`. If you only pass the device ID, then the API assumes you want to toggle the entire strip. I just updated my cheat sheet / documentation page with this extra information and an example POST request - you can find it here docs.joshuatz.com/random/tp-link-kasa/#endpoints-and-methods (scroll down to "Power Strip: Turn individual plugs on and off"). Let me know if this helps, or you are looking for more / different info. Regards, Joshua

Hi guys. Im sending this message on a couple of Shanes videos as I know how helpful he and his community is. I have a question that I cannot find on google. Im using powerapps with sharepoint to run a couple of shops I have. The shops report daily on powerapps what the days expenses, income etc were. Is there a way that I can summarise the daily income from all the shops in a manneer that it can be viewed back im a gallery on powerapps? Not sure if powerapps/sharepoint has this function? Thanks!

@ShanesCows

2 жыл бұрын

Power BI would be the ideal answer. Second best might be to have a flow that does the crunching for you so you can just view. Something like the video I am about to find a link to.

@ShanesCows

2 жыл бұрын

Here is the video you need. kzread.info/dash/bejne/iGWIyqOFkdnclpM.html

@erwin8335

2 жыл бұрын

Shane Young Thanks Shane appreciate it!

Great video. but where do we got to setup the credentials - email and password to the TP-Link Cloud?

@ShanesCows

3 жыл бұрын

If you have a Kasa device you install the app on your phone and create an account from there. That account is what you use.

@haroldbk

3 жыл бұрын

@@ShanesCows thank you. That's what I needed. Now to get the device :)

@ShanesCows

3 жыл бұрын

The dimmer was a nice addition to my office but did require me doing electrical work. EEK! The smart plugs are super easy to use and just plug in so might be easier to just play with.

@haroldbk

3 жыл бұрын

@@ShanesCows I got the mini plugs to work but haven't tackled installing the dimmer switch, yet

Hey Superstar! Any chance you're going to do a video on how to work with the "When a http request is received" connector within the context of a solution so that when you migrate the solution your messaging webhook plugin for the data verse automatically updates?

@ShanesCows

2 жыл бұрын

Yikes, I haven't done anything like that before. I have only used When HTTP received once and it wasn't anything too fancy.

@bronsondh

2 жыл бұрын

@@ShanesCows Well - since I originally posted this message, I've discovered it can be done with a custom connector. Same same, just the reverse of the more common way of creating a custom connector..... Your videos are great btw ;-) You've spent many hours with me in my living room. ';-)

IOT learning was really fun. But please help me with my earlier request. I'm still learning PowerApps.

@ShanesCows

3 жыл бұрын

I respond to comments as I can. Guessing whatever you asked it wasn't a quick answer that is why I haven't responded yet. Sorry, I get 1000s of comments and I do my best to keep up

cool ~~

@ShanesCows

3 жыл бұрын

Thanks

It’s not IoT but can you look at sending graph an http request to create planners?

@stanleym69

3 жыл бұрын

Actually managed to work this one out. Needed some azure app registrations and a service account. The way planner is set up now. The user needs to be an owner of a team before you can create the planner

@ShanesCows

3 жыл бұрын

Hey Sam glad you got it. Graph and SharePoint APIs are on my list for sure. :)

Action 'HTTP' failed 302 :(

@ShanesCows

2 ай бұрын

I just ran that exact flow and it still works. Look for typos. :)

What does this say, I don't care, it's a bunch of words LMAO. It's like me reading a book lol.

@ShanesCows

3 жыл бұрын

Reading is for the birds. 😂

Thank you!

@ShanesCows

3 жыл бұрын

You bet! I hope you do something fun with the concepts.