Dear All,
I have a Microsoft form, the user enters data in each field then power automate passing this data to SharePoint List, my issue is if the user entered special characters in each field I want power automate to ignore the request and do not create an item in SharePoint list and i have tried the following ,
1- created a condition and add each character in a separate row (it works well but i need to collect them in one row) by contains if the value contains @/*- etc do not create item in SharePoint List
2- tried to add compose with all characters and in the condition compose field contains compose outputs did not sucess also
I need to collect all special characters in one compose then compare the outputs by contains if the user enters one of any special character do not create item for example
1- test1@ do not create
2- test#/* do not create and so on
3- test create item
thanks in advance