I am building a search form to search CRM and manipulate the returned rows.
I want to be able to search the CRM on one or more Account Names.
I am working on the basis the user will enter a string such as "account1, account2, account3" into a field on a form and the system will return the Account Rows where the name Contains account1, account2 or account3.
My plan was to use the searchrecords function but as this only allows one search criteria I have to run round it several times to cover all the names the user wishes to search.
To do this I was going to us a For Each loop around a list, so the question is how do I turn
"account1, account2, account3"
into a list?
List:String({input.SearchField}) does not work.
Any ideas?