Power automate

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

So, some of you may have read my post a month or so ago about about how I can automate the boring tasks I have to do, well, I was looking around and came across power automate and I have nearly finished my first automated task. What I have basically done is created a flow that will open a browser, log me into a website and download 2 excel sheets and then log out of the website, the last part is crucial as if you are still logged in, the flow fails.

I wont say its been plain sailing but possibly something worth people looking into. The next thing I want to do with this process is to be able to schedule it to run daily and then email those files to a teams channel with the date but also send me a notification via email if it was successful or not.

After this there are lots of other similar things I am looking to do, thankfully we have been quiet(ish) and I have had the time to look into it.

Give it a go and see what you think

Ed

 

I played with MS Flow when it first came out, couldn't really do what I need and seemed basic.. guessing its improved a lot as this is going back years.

 

Yeah, it seems that way

My auto login and download some specific files program is handy. I havent had the time to get it to run automatically and date the files, but that shouldnt be too much of an issue

Ed

 

You can achieve the same thing with python/selenium and it'd probably be more flexible. Here's a really basic script I wrote to automatically buy a ps5 off Amazon when they came in stock:

https://github.com/Ps3ud-0nym/python-amazon-bot/blob/master/main.py

 

Thats impressive @Pseudonym

May look to that logic and see what I can do. My power automate one has fallen over where the UN is typed.

Zx

 

Thanks mate. Give me a shout if you need a hand with anything.

 

I have a question but I am not sure if my thinking is correct.
I mention above that the power automate I created was working, have the video to prove it, but now it doesn't. The only change I have made is upgrading the ram on my pc, from a 4 gb to an 8 gb, giving me a total of 16gb overall. Seeing as the program failed after Firefox launched, in the windows where the username would be entered, would this mean that its lost its place so to speak as in it knew where to type the text automatically but because I have changed the ram, the position of the pointer click or input was wiped or changed?

I hope that makes sense, I think it does but knowing me I may be barking up the wrong tree?
Zx