Powershell script works, but in PowerAutomate it says syntax error

(0) Share

Report

Posted on by BruceR

Hi,

I have this script that searches the members of a group to see which AD accounts are disabled.

It works perfectly if I run it in Powershell but Power Automate Desktop says it has a syntax error.

Any ideas ?

Thanks

 get-adgroupmember -Identity groupname | %{Get-ADUser -Identity $_.distinguishedName -Properties Enabled | Where-Object{$_.Enabled -ne $true}} | Select name, DistinguishedName,Enabled | Format-Table -Property * -Autosize

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @BruceR

I could see you have used % sign in script

using % in PAD mean you are trying to use variable here, May i know are you passing any variables here,

Was this reply helpful? Yes No
BruceR 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

actually the % character is an alias for ForEach-Object .
But in fact you are correct that the % is the problem.
I swapped % for ForEach-Object and the script now works.

Thanks for your help. Where should I report this bug ?

Kind Regards

Bruce

Was this reply helpful? Yes No
BruceR 16 on at

Like (1)

Report
Copy link

Link copied!

I found the Feedback option in PAD.
Thanks again
Bruce

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @BruceR

It should work when adding %'%'% instead of % only

Take this example of running this script in PAD

Output will be like below

In your case, you need to modify script like below

Hope this helps

Mark it as solution if this resolves your query

get-adgroupmember -Identity groupname | %'%'%{Get-ADUser -Identity $_.distinguishedName -Properties Enabled | Where-Object{$_.Enabled -ne $true}} | Select name, DistinguishedName,Enabled | Format-Table -Property * -Autosize

Was this reply helpful? Yes No
BruceR 16 on at

Like (0)

Report
Copy link

Link copied!

thanks @Nived_Nambiar I understand it I think now.
So this is a clash between the two systems Powershell and PowerAutomate.
Both use % for different things.
I guess it is better to not use Powershell aliases.

Kind Regards

Bruce

Was this reply helpful? Yes No