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
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.
Hey Kevin - Not sure where you are on your journey but I did get more detailed on APIs here th-cam.com/video/p8ErJU43N74/w-d-xo.html Covered deeper JSON here th-cam.com/video/G6dU5me5h1o/w-d-xo.html Cover SharePoint API here th-cam.com/video/JkcyiQ-OIkU/w-d-xo.html What other API stuff would you like to see?
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
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...!
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.
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']}" } }
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...
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.
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.
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
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 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.
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.
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.
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...
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
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!
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.
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.
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 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
i am having a problem with the api, how can I refresh the API token? i am having a status code 401 and the message is "Unauthorized/Invalid token". the API I made expires but while the flow is still running.
I haven't ran into that, do you maybe to repeat your authenticate action periodically to get a new token. So that step at the top run it after a few actions to get a fresh token.
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!
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.
@@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
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 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. ';-)
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
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?
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
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.
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
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
Awesome. Glad it helped. 🐶
Awesome, i have used this to run API for my Bulk SMS account, working so well, Thank you Shane
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!
Awesome, that is my goal. I am not a developer either so always fun to learn together.
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.
Glad to help. 😀
Finally it's here...Thank you so much Shane for creating this video...😁😊🎉
Happy to help Devang
Fun demo! Yes, let's keep digging deeper (custom connectors, Azure API Management, all things external integration).
More to come! I enjoyed the API stuff.
Thank you so much for adding hilarious personality to educational content. Well done!
Thanks BJ. I know this stuff is boring so I do my best to bring a touch of fun to it.
this is awesome, when I get moved into my new house, I will DEFINITELY be re-watching this video. (also: FIRST)
Wes you are the best. Hope all is well and congrats on the new place.
yes jumping deeper into setting up the power app of turning lights off and on would be great possible seeing
Hey Kevin - Not sure where you are on your journey but I did get more detailed on APIs here th-cam.com/video/p8ErJU43N74/w-d-xo.html
Covered deeper JSON here
th-cam.com/video/G6dU5me5h1o/w-d-xo.html
Cover SharePoint API here
th-cam.com/video/JkcyiQ-OIkU/w-d-xo.html
What other API stuff would you like to see?
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
Great Again! Here to learn how how to post a SharePoint list to an external system using RestAPI and JSON upon list change.
Really fascinating video. Amazing explanation. Thanks Shane
Glad it was helpful!
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.
Thanks. Premium isn't ideal but one $15 license should cover you for all of hte flows you need for you.
Where is the love button on TH-cam?? Great content!!! 👍
Wow, thank you!
Thank you, Thank you Shane this is greatly helpful even for a former developer !!
Awesome!
Thank you! Shane. always coming up with great stuff.
Thanks, you are very kind.
@@ShanesCows Hey Shane, got "error -2002" "request timeout" any advise? Thank you!
Thanks Shane, really excellent breakdown and walk through.
My pleasure!
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...!
You are very welcome. Glad it had lots of little tips to help.
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.
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']}"
}
}
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...
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.
Will do. Custom connector would be easier but it does change licensing. 😎
love it "kinda nerdy......but not super scary"
🤓😎
Great video, how about Patch Method to update?
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.
Hello Shane, thanks for this amazing video. Is there any available way to access Kasa spot KC105 and display its live recording in powerapps?
I don’t know. I don’t have one of those to play with. 😑
why you are so good at tutoring?🙃
This awesome, thank you so much for your time!
My pleasure!
I have to tag this and come back to it later
By the way thanks from down under
Glad to help. This is a fun video for sure.
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
I replied to your other comment. Using HTTP action with SharePoint is not premium.
What was the authentication used in HTTP trigger
It’s awesome and I’m looking forward to watching it 😄
I hope you enjoy it. The video was a lot of fun.
The lord of the rings comment made me like and subscribe xD
I always love slipping in some small movie/tv reference 😍
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
If I get my hands on any cool stuff like that I will for sure. :) Do you have recommendations on cheap sensors with APIs?
@@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.
@@ShanesCows Philips Hue light
Thanks Shane. Is there a way to submit a GET request with Body? I get an error, the creator of the service did it that way. 😞
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
Interesting idea. 😎
Thank you Shane!
Happy to help John.
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.
Great video. but where do we got to setup the credentials - email and password to the TP-Link Cloud?
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.
@@ShanesCows thank you. That's what I needed. Now to get the device :)
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.
@@ShanesCows I got the mini plugs to work but haven't tackled installing the dimmer switch, yet
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...
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
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,
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
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!
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.
Here is the video you need. th-cam.com/video/V1ThALavvf0/w-d-xo.html
Shane Young Thanks Shane appreciate it!
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.
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?
The Tesla API needs to be done. :) Twilio I will ponder on. I haven't used it much.
@@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
i am having a problem with the api, how can I refresh the API token? i am having a status code 401 and the message is "Unauthorized/Invalid token". the API I made expires but while the flow is still running.
I haven't ran into that, do you maybe to repeat your authenticate action periodically to get a new token. So that step at the top run it after a few actions to get a fresh token.
Great one thanks!
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!
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.
@@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
Thanks Shane
You are welcome Sundra. Have a great day.
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?
Yikes, I haven't done anything like that before. I have only used When HTTP received once and it wasn't anything too fancy.
@@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. ';-)
Can we get the 3rd part of responsive controls :) thanks Shane!
Fair request. I do need to dig deeper on those again. It is on the list, just to find the motivation now.
@@ShanesCows you the man !
IOT learning was really fun. But please help me with my earlier request. I'm still learning PowerApps.
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
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?
Nope, you will have to use the HTTP action.
@@ShanesCows is it a premium feature to use or no
una consulta, es posible consumir apis que tiene formatos de xml tanto de envio y respuesta ???
Thank you!
You bet! I hope you do something fun with the concepts.
Great, please asd a video and store iot data on dataverse to display it into powerapps….
Noted. Thanks
It’s not IoT but can you look at sending graph an http request to create planners?
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
Hey Sam glad you got it. Graph and SharePoint APIs are on my list for sure. :)
cool ~~
Thanks
What does this say, I don't care, it's a bunch of words LMAO. It's like me reading a book lol.
Reading is for the birds. 😂
Action 'HTTP' failed 302 :(
I just ran that exact flow and it still works. Look for typos. :)
Please calm down, you talk way too fast.
Sorry, sometimes I get too excited. You can always use the TH-cam controls n the bottom right corner to slow the speed. 😎
Thank you!
You bet! This one was very fun for me to learn about.