Power Platform Community Forum Thread Details

Hi Team.

The below query is not deleting any record in power automation, while it is deleting records in Sql Server.

Delete A from TblREM A Join DimIndividualProfile IPV (NOLOCK) ON A.IndividualID = IPV.IndividualID where IPV.EmailAddress like '%@%microsoft%'

Also i tried to execute this query in "Execute Sql Statement" after replacing % with \ but no result.

Please help me on this.

Thanks in Advance.

Categories:

Issue with like opetator and special char.