cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Special characters on Sharepoint field

Hi all!

I'm trying to make a flow that save in to a sharepoint list the subject of a mail as title, but if the mail is forwarded it contains special characters as ":" and the flow fails.

There is a method for filter dynamic content subject and obtain it without special characters?

3 REPLIES 3
Microsoft
Microsoft

Hi @mirkio90,

 

I'm trying to use compose to solve the problem, but it result in outputing replace(test:test,':',") instead of the real value.

But we are working on a feature to solve the problem. Thanks for the paitence.

 

Thanks

Community Support
Community Support

Hi @mirkio90,

 

There is no way to filter the Dynamic content, unless it is an array (which we could take use of the filter Array Action).

As mentioned by telu, we could take use of the Compose Action here to Split the Content and then have it without the special characters.

Please take a try with the following steps to add the Compose:

Under the Input part, copy and paste the following (with the double quote):

"@split(triggerBody()?['Subject'],':')[1]"

If your original Subject didn't contain the " : ", then the outputs of the compose would be the original Subject string.

14.PNG

15.PNG

 

Please take a try with the method above, if you have any further questions, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @mirkio90,

 

Any update here?

If you need any further help, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (4,369)