Shane man, I can't thank you enough, I watched almost all your Powershell related videos and it is always a pleasure learning from you. You made Powershell learning easy. Thank you so much for your time and efforts.
I've slowly been getting more familiar with PowerShell because of my job in IT and all I can say is its a necessity for any type of bulk updating or making a simple change to settings that you normally don't change. I used it to bulk update a default value in a new column I created to categorize items in SharePoint the other day, and watching it run a script is as satisfying as popping bubble wrap or taking off that new electronic plastic. Not to mention GPT can help write any script in it in no time. Thanks for this Shane. Automate with PS is something that has always baffled me. Not anymore.
Hi Shane! Fantastic intro to this! I'm a sysadmin and huge proponent of using PowerShell wherever possible. Our company is just getting into Flow and PowerApps more, so this will be huge to administer this sort of thing more efficiently. No questions at this time other than that I'm looking forward to your follow-up videos on this topic. Thank you for what you do!
Great tutorial! I've got an employee lookup app that's connected to aadusers table and it only populates information for the global admins account. I think it has something to do with Graph but I can't find a role or permission to assign users to allow the read from aadusers. Is there something in PowerShell for PowerApps to allow all users in the tenant or a specific group within the tenant access to aadusers?
Hi Shane, Is there any way to delete desktop flows of other users programmatically? I dont find a commandlet for desktop flow. Could you please let me know if there is any other way through powershell or powerautomate?
Shane, its really cool to manage powerapps from Powershell. Is there a way I can invoke a Powershell from a Canvas app ? Like to update something on az using PS
Is it possible to create/manage solutions with power apps, flows, connections, environment variables , export solution, import in environment with PowerApps?
Great video once again. Do you have a video regarding pushing a powershell script from powerapps ui, example: i need to unlock an AD account or to change a password, very convenient to do so from my cell instead of returning to my pc
@@ShanesCows Great, will explore the api option as I do not currently have Flow , keen to see your content regarding this. Thanks for the prompt response
Hey Shane... LOVE all your videos. I was looking and hoping you may have one the basically shows me how to simply list all of the power automate flows in my environment, and their owner(s) name? Sounds so simple, but I cannot for the life of me the command to do that? Do you have one out there possibly?
@@ShanesCows Get-AdminFlow -EnvironmentName |foreach {"Flowname:$($_.Displayname)`n OwnerName: $((Get-AzureADObjectByObjectId -ObjectIds (Get-AdminFlowOwnerRole -EnvironmentName -FlowName $_.FlowName).PrincipalObjectId).Displayname)`n" } You will need to connect to PowerApps and AzureAD in your PowerShell session to run the above.
Get-AdminFlow -EnvironmentName |foreach {"Flowname:$($_.Displayname)`n OwnerName: $((Get-AzureADObjectByObjectId -ObjectIds (Get-AdminFlowOwnerRole -EnvironmentName -FlowName $_.FlowName).PrincipalObjectId).Displayname)`n" } You will need to connect to PowerApps and AzureAD in your PowerShell session to run the above.
Shane, I've run into an issue I'm wondering if you've run across. I'm currently working on a bunch of integrations between Tyler MUNIS (SFTP) and an on-prem server using Power Apps dataflows to transform data. All was working as expected until Tyler MUNIS forced a password reset on the server credentials. It appears that on the back end, each SFTP connection is trying to maintain a connection with the server even if the flow is disabled, bombarding it with incorrect credentials and getting us locked out of the account. This means each time it forces a password change, which we cannot modify the interval for as it's a 3rd party, we have to disable each flow, delete the connection in the "connections" tab so the SFTP connections break in the flows, create a new connection, then open each flow and reconnect them. Is there a way to do this in more of a blanket fashion using powershell? It's really a nuisance to manually perform this action every month. I suppose put simply, the tools I'm looking for using powershell are: delete / create power platform connections, apply connections to Power Automate flows.
Would be great to have a follow up to this and go a bit more in depth. I have an ulterior motive... trying to find a way to query what flows are linked/associated with a power app using PowerShell. There are commands like Add-AdminFlowPowerAppContext and Remove-AdminFlowPowerAppContext but glaring omission seems to be GET-AdminFlowPowerAppContext ?
Thank you very much for this. Can this information be made available in Power Apps again? What I am specifically looking for is how to make the apps shared with the logged in user available in Power Apps.
Thanks for your response, let me clarify. I'd like to have a reference to all the apps shared with the user available in Power Apps itself. Ideally this would be a call in which all the 'guids' of apps shared with the logged in user would could be stored in a collection, it would allow a 'central app' to be the starting point from which a user could then launch all other shared apps.
Hi Shane, Thanks for your reply and all the vids. I discovered the scenario I was looking for is available in the (Preview) PowerApps for Makers connector. I think that if you're looking for inspiration for more content (which I don' t think you lack), this connector might be an interesting angle for more people. Starting PowerApps from PowerApps, getting version data etc.
When trying to use the Set-AdminPowerAppApisToBypassConsent command I get an error that more or less says "The user does not have an entitlement to use PowerApps". I am a global admin. What could the problem be?
Great video! Is there a way to initiate a PowerShell command from Flow / PowerApps? For exemple create a user in AD from PowerApps through a on-prem gateway?
Hi Shane, great video!! Could you maybe make a tutorial on how to recover deleted apps (in PowerApps)? i logged into my account today and found out that the app ive been working on for a month is gone. I have a feeling this moght have happened due to an unexpected crash or failure to save changes. Could you help explain why this might have happened?
Hi shane, thanks for such a cool video, really learned a lot! I just wanted to ask, is it possible to change the original owner (creator) of a Power Automate thru PowerShell? We have a requirement to change the original owner of our Flows from a named user account to a service account? I'm just wondering how can we do it? thank you!
The video shows how to do it for Power Apps which I have done for a customer. I haven't done it for flow but I think there is a similar cmdlet in there.
While running Set-AdminFlowOnwerRole I am getting error cannot bind argument to parameter 'ResponseObject' because it is null although I am running the command from admin account also, set-PowerAppsRoleAssignment does work. Not sure what the issue is. So basically all PowerApps commands work fine but PowerAutomate commands fail
Shane, Could you do a video on DSC, please? In particular, I am looking at using DSC with Hyper-V to make Windows 10 images. If you could throw in information on using ReverseDSC to get a starting point that would be ideal. Keep up the great work...
Shane man, I can't thank you enough, I watched almost all your Powershell related videos and it is always a pleasure learning from you. You made Powershell learning easy. Thank you so much for your time and efforts.
Glad you like them!
I've slowly been getting more familiar with PowerShell because of my job in IT and all I can say is its a necessity for any type of bulk updating or making a simple change to settings that you normally don't change. I used it to bulk update a default value in a new column I created to categorize items in SharePoint the other day, and watching it run a script is as satisfying as popping bubble wrap or taking off that new electronic plastic. Not to mention GPT can help write any script in it in no time. Thanks for this Shane. Automate with PS is something that has always baffled me. Not anymore.
I love this!
Hi Shane! Fantastic intro to this! I'm a sysadmin and huge proponent of using PowerShell wherever possible. Our company is just getting into Flow and PowerApps more, so this will be huge to administer this sort of thing more efficiently. No questions at this time other than that I'm looking forward to your follow-up videos on this topic. Thank you for what you do!
Glad to help. 😀 Brendan. I love PowerShell
Hey Shane, congratulations on another video. Topic seems intriguing. PowerShell and PowerPlatform is a mouth watering scenario. Great show.
Thanks 😊
Excellent, Shane. Thanks so much.
Happy to help
Great video !! Powershell is really intresting and powerfull honestly
It really is! Enjoy the power it gives you and now with ChatGPT learning it is even easier.
Thanks Shane, another great video!
Thanks 😊
Very helpful video.Thankyou
Happy to help, have a great day!
Great tutorial! I've got an employee lookup app that's connected to aadusers table and it only populates information for the global admins account. I think it has something to do with Graph but I can't find a role or permission to assign users to allow the read from aadusers. Is there something in PowerShell for PowerApps to allow all users in the tenant or a specific group within the tenant access to aadusers?
Hi Shane, Is there any way to delete desktop flows of other users programmatically? I dont find a commandlet for desktop flow. Could you please let me know if there is any other way through powershell or powerautomate?
Shane, its really cool to manage powerapps from Powershell. Is there a way I can invoke a Powershell from a Canvas app ? Like to update something on az using PS
Not directly. THe best answer we have found is to create an Azure Function and then trigger it via the API with flow. 😑
Is it possible to create/manage solutions with power apps, flows, connections, environment variables , export solution, import in environment with PowerApps?
Not sure, I have never tried.
Great video once again. Do you have a video regarding pushing a powershell script from powerapps ui, example: i need to unlock an AD account or to change a password, very convenient to do so from my cell instead of returning to my pc
I don’t but need to. You would have to have flow trigger a logic app to run PowerShell. Or what if you do it via the graph api directly 😁
@@ShanesCows Great, will explore the api option as I do not currently have Flow , keen to see your content regarding this. Thanks for the prompt response
@ShanesCows Hi Shane. I did a lot of research and I found nothing about importing Flows with a script. Do you have any ideas?
I have never tried, so I don't have anything. Sorry
Thanks for inspiration!
Welcome. 😎
Great video Shane!!! But I have ONE question Is it possible to look a member of for one or several group Active Directory on PowerApps?
I am not sure. I have never tried that
Thanks ! Is there a way to get data from Dataverse (CDS) with powershell ?
Not that I know of. 🤔 Seems like there should be bit I don’t know how
Hey Shane... LOVE all your videos. I was looking and hoping you may have one the basically shows me how to simply list all of the power automate flows in my environment, and their owner(s) name? Sounds so simple, but I cannot for the life of me the command to do that? Do you have one out there possibly?
Stacy I haven't done that, and I can't get my PowerShell to open at the moment. BOO.
@@ShanesCows Get-AdminFlow -EnvironmentName |foreach {"Flowname:$($_.Displayname)`n OwnerName: $((Get-AzureADObjectByObjectId -ObjectIds (Get-AdminFlowOwnerRole -EnvironmentName -FlowName $_.FlowName).PrincipalObjectId).Displayname)`n" }
You will need to connect to PowerApps and AzureAD in your PowerShell session to run the above.
Get-AdminFlow -EnvironmentName |foreach {"Flowname:$($_.Displayname)`n OwnerName: $((Get-AzureADObjectByObjectId -ObjectIds (Get-AdminFlowOwnerRole -EnvironmentName -FlowName $_.FlowName).PrincipalObjectId).Displayname)`n" }
You will need to connect to PowerApps and AzureAD in your PowerShell session to run the above.
Is it possible to migrate power apps from one tenant to another using powershell
NOt that I know of. 😐
Hi Shane, just a quick question. Can you please help me with the script where I can extract list name of a particular flow using power shell?
Shane, I've run into an issue I'm wondering if you've run across. I'm currently working on a bunch of integrations between Tyler MUNIS (SFTP) and an on-prem server using Power Apps dataflows to transform data. All was working as expected until Tyler MUNIS forced a password reset on the server credentials. It appears that on the back end, each SFTP connection is trying to maintain a connection with the server even if the flow is disabled, bombarding it with incorrect credentials and getting us locked out of the account. This means each time it forces a password change, which we cannot modify the interval for as it's a 3rd party, we have to disable each flow, delete the connection in the "connections" tab so the SFTP connections break in the flows, create a new connection, then open each flow and reconnect them. Is there a way to do this in more of a blanket fashion using powershell? It's really a nuisance to manually perform this action every month. I suppose put simply, the tools I'm looking for using powershell are: delete / create power platform connections, apply connections to Power Automate flows.
Awesome ! Hey Shane could you please give a demo on how these powershell commands / script can be utilized in a real time scenario.
I don’t understand.
Would be great to have a follow up to this and go a bit more in depth. I have an ulterior motive... trying to find a way to query what flows are linked/associated with a power app using PowerShell. There are commands like Add-AdminFlowPowerAppContext and Remove-AdminFlowPowerAppContext but glaring omission seems to be GET-AdminFlowPowerAppContext ?
Thank you very much for this.
Can this information be made available in Power Apps again? What I am specifically looking for is how to make the apps shared with the logged in user available in Power Apps.
Sebastian I don’t follow what your are trying to do?
Thanks for your response, let me clarify. I'd like to have a reference to all the apps shared with the user available in Power Apps itself. Ideally this would be a call in which all the 'guids' of apps shared with the logged in user would could be stored in a collection, it would allow a 'central app' to be the starting point from which a user could then launch all other shared apps.
@@sebastiangoy7412 your app won't be able to talk to powershell, but you can certainly leverage this information using the admin connectors and flow
Sorry not possible in the app. 😔
Hi Shane, Thanks for your reply and all the vids. I discovered the scenario I was looking for is available in the (Preview) PowerApps for Makers connector. I think that if you're looking for inspiration for more content (which I don' t think you lack), this connector might be an interesting angle for more people. Starting PowerApps from PowerApps, getting version data etc.
Great ,
Using powershell Can we migrate a SP list model-driven power app in to another list ..? Atlest between Same version
Reply please.
Not that I know of. Sorry
When trying to use the Set-AdminPowerAppApisToBypassConsent command I get an error that more or less says "The user does not have an entitlement to use PowerApps". I am a global admin. What could the problem be?
You need to log into the admin portal for Power Apps one time first I think is the issue. admin.powerplatform.microsoft.com/
Great video!
Is there a way to initiate a PowerShell command from Flow / PowerApps?
For exemple create a user in AD from PowerApps through a on-prem gateway?
There are some options here. We have done this via azure logic apps but I don’t have any content to share.
Hi Shane, great video!! Could you maybe make a tutorial on how to recover deleted apps (in PowerApps)? i logged into my account today and found out that the app ive been working on for a month is gone. I have a feeling this moght have happened due to an unexpected crash or failure to save changes. Could you help explain why this might have happened?
Yikes. I haven't ran into that as an issue. If you open a support ticket with Microsoft they can hopefully restore it for you. Good luck.
Hi shane, thanks for such a cool video, really learned a lot! I just wanted to ask, is it possible to change the original owner (creator) of a Power Automate thru PowerShell? We have a requirement to change the original owner of our Flows from a named user account to a service account? I'm just wondering how can we do it? thank you!
The video shows how to do it for Power Apps which I have done for a customer. I haven't done it for flow but I think there is a similar cmdlet in there.
Anyways to overcome the upload size limit of just 100 MB to the blob?
Not that I know of. I am also fighting this issue. 😑
While running Set-AdminFlowOnwerRole I am getting error cannot bind argument to parameter 'ResponseObject' because it is null although I am running the command from admin account also, set-PowerAppsRoleAssignment does work. Not sure what the issue is. So basically all PowerApps commands work fine but PowerAutomate commands fail
Shane, Could you do a video on DSC, please? In particular, I am looking at using DSC with Hyper-V to make Windows 10 images. If you could throw in information on using ReverseDSC to get a starting point that would be ideal. Keep up the great work...
Hey Kevin - I have never done DSC. Sorry
@@ShanesCows Alrighty. When you do, let me know. I'll be interested to hear how you explain it. Keep up the great work!
How do i get those info like
1. Powerapp last access and launch by who and when?
2. Flow last run by who and when?
Both products have an Analytics page with lots of info
Yes I know but they only show max 28 days of data...