u/Chemical_Ad6984

Hi all,

Does anyone know a good way to run python scripts through powerapps?

I’ve built a canvas app (standard license, no premium features) and it’s shared across a department of 70.

It’s a scheduling/planning tool for the department and the last feature id love to add is the ability to automate scheduling of tasks (~100 scientific assays a week)

The scheduling is a bit complex, we have to schedule to people who are available and trained in the methods and assign work closest to the sample available date and consider the due dates. It’s something which I’ve building a good python script to do - but I’m not sure how best a powerapp can run it.

Ideally the script could be run by any user when they need to, is this possible?
Or are there any alternatives?

I’ve been given a co-pilot license and trying to integrate co-pilot into the app for it “auto- schedule” but i don’t think co-pilot is any good and I’ve been able to get anywhere with it.

Thanks for any help! I actually posted on this community about 9 months asking if I’d be able to build a powerapp for scheduling/planning and now I’ve done it, it’s deployed to great feedback and other departments and sites are asking if I can make them one!

Long story short work has gone back to 5 days in office, I joined during hybrid working (3 days in/2 days remote) very quickly didn’t work for me so informally have been doing 2 days in/3 days remote due to my role as carer for my wife who has disability. All 3 line managers across 2.5years have been fine with this, with no impact to performance.

It’s also a 4hr round trip drive to work, which is a factor for how being on site makes those days particularly struggling for me and my family - with the flexibility it was manageable. Work have said distance and child care will not be considered for flexible working.

Submitted flexible working request based around my role as a carer, and with full support of manager - this has now been rejected by SLT, they counter offered 1 day remote. It’s the usual bs about collaboration and communication. They are approving other flexible working requests with similar (not exact) roles but would demand equal levels of collaboration and onsite presence.

They are also using RTO as a way to get free redundancies as we are not recruiting for lost personnel. It does feel targeted that my request was rejected.

I want to appeal and ask for 2 days remote, therefore majority of week is still on site. What are my chances with an appeal? How best do I make my argument?

Is there anything else I can do? Paralysed with stress - have no idea how my wife will cope, or secondary, how I’ll manage.