VLookup – how to handle string with single quote?
- This topic has 5 replies, 2 voices, and was last updated 1 year, 3 months ago by .
Viewing 5 reply threads
Viewing 5 reply threads
- You must be logged in to reply to this topic.
Home › Forums › Modern DFFS › VLookup – how to handle string with single quote?
Tagged: vlookup single quotes
I’ve run into a slight issue with using a string as a vlookup filter. Occasionally there is a single quote contained in the string, and then the vlookup fails as you’d expect.
Does anyone have a workaround or method to handle this situation? Ideally I’d like to avoid amending the source data if at all possible.
I had the same issue in power automate and managed to work around it with a replace:
Title eq ‘@{replace(triggerOutputs()?[‘body/Title’], ””, ”””)}’
So something along the same lines with DFFS would be great (set a variable via custom JS?)
Screenshots of the current config and error attached.
Any help gratefully received
Thanks
Adam
Hi,
I’ll fix this by adding a check for single quotes (and replace with two single quotes as this is the format used in the SharePoint REST API) in all places where a REST filter is built in the code. I’ll try to get it out later this week.
Alexander
Thanks Alexander, that would be amazing.
The new version ha been published – let me know how it works out.
Alexander
Thank you, updated and working perfectly now. Tested with various permutations of multiple single quotes, no issues at all.
Thanks for the feedback, I’m glad it fixed the issue.
Alexander