Unable to get user (Send an HTTP request to SharePoint) when email contains apostrophe

[cattre]

Hi,

I've recently noticed flows failing due to the HTTP request action not being able to retrieve the user ID from SharePoint for users with an apostrophe in their email (it works with all other users). The error message just implies it's not a valid request:

The expression "web/SiteUsers/getByEmail('firstname.O'lastname@domain.com')" is not valid.

Is there a workaround (e.g. escape character) to pass in email addresses with apostrophes? If not, is this a known issue that's likely to be resolved any time soon? Any other suggestions for how I can retrieve user IDs from SharePoint?

Thanks! 

[abm]

Hi @cattre 

Try using expression encodeUriComponent to convert the email single quotes to %27

Thanks

[cattre]

@abm thanks for the suggestion. Tried with both encodeUriComponent and UriComponent (the latter is apparently "preferred" by MS for some reason). The input to the request looks good:

_api/web/SiteUsers/getByEmail('firstname.O%27lastname%40domain.com')

Unfortunately it still throws the same error. The output shows the email address with unencoded characters (i.e. same error message as before).

[abm · Accepted solution]

Hi @cattre 

I was expecting that should work. Ok please try hardcoding the email as a test with two %27. Please see below.

_api/web/SiteUsers/getByEmail('firstname.O%27%27lastname%40domain.com')

If that works then try replace expression to convert single quote to two %27.

Thanks

[cattre · Accepted solution]

@abm perfect, thanks! For reference, I used the replace function as below:

replace(body('Get_user_profile_(V2)')?['mail'],'''','%27%27')