Unanswered

502 BadGateway - Invalid URI when creating folder on SharePoint using subject line of incoming email

(0) Share

Report

Posted on by simpim

I have created a simple automated flow for certain incoming emails that creates a folder on SharePoint and uploads the body of the email and any attachments to said folder. The folder is named using the subject line of the incoming email.

Sometimes this flow fails at the create folder stage due to the following error message, "Invalid URI: The format of the URI could not be determined."

My initial thought was that this may be due to invalid characters in the subject line of the email. Is there a way to replace invalid characters with another character or any other workaround?

Manny

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

RezaDorrani 12,143 on at

Like (4)

Report

Hi @simpim

use this expression to remove all special characters

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(variables('artifactName'),':',''),'%',''),'#',''),'*',''),'<',''),'>',''),'?',''),'/',''),'"',''),'"',''),'@',''),'&',''),'=',''),'/',''),';',''),'|',''),'\',''),'[',''),']',''),'~',''),'{',''),'}',''),'^',''),'!',''),',',''),'.',''),' ','')

variables('artifactName') - can be updated with you email subject

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @simpim,

Have you solved your problem according to @RezaDorrani's suggestion?

If yes, you can mark Accept his reply as the solution to help the other members find it more quickly.
If no, could you share your folder name instance? If so we can assist you better.

Was this reply helpful? Yes No
simpim 5 on at

Like (0)

Report

Yes, it works now!

Thank you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Reza for you contribution to the Power Platform.

Was this reply helpful? Yes No