VLookup – how to handle string with single quote?

[AdamP]

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

Attachments:

1. 

   VlookupConfig.png
   

2. 

   VLookup-single-quote-error.png
   

[Alexander Bautz]

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

[AdamP]

Thanks Alexander, that would be amazing.

[Alexander Bautz]

The new version ha been published – let me know how it works out.

Alexander

[AdamP]

Thank you, updated and working perfectly now. Tested with various permutations of multiple single quotes, no issues at all.

[Alexander Bautz]

Thanks for the feedback, I’m glad it fixed the issue.

Alexander

[Author]

Posts