Hi All,
I am working on a project where I need to use filter in collection manipulation. I need to pass Data (coming through other collection) and filter data through other collection with given input.
Collection A has Case ID, Name and Subject.
Collection B has Name and Email ID and other details.
Now I get Name from collection A and filter it in B. Below is the syntax I have used:
"[Name]= "&[CollA.Name]&""
This was working fine. I got one name as Kat O'Reill. So bot is throwing an error of having single quote in name. I tried by putting single quotes in formula shared above but single quote will still exist and bot is unable to fetch data. If I remove single quote then BOT runs but it fetches no data. For normal scenario without having single quote, bot runs correctly.
Any suggestion for this problem?
I am working on a project where I need to use filter in collection manipulation. I need to pass Data (coming through other collection) and filter data through other collection with given input.
Collection A has Case ID, Name and Subject.
Collection B has Name and Email ID and other details.
Now I get Name from collection A and filter it in B. Below is the syntax I have used:
"[Name]= "&[CollA.Name]&""
This was working fine. I got one name as Kat O'Reill. So bot is throwing an error of having single quote in name. I tried by putting single quotes in formula shared above but single quote will still exist and bot is unable to fetch data. If I remove single quote then BOT runs but it fetches no data. For normal scenario without having single quote, bot runs correctly.
Any suggestion for this problem?