Removing trailing spaces (Trim?) from dynamic content

Like (0) Share

Report

Posted on 13 Dec 2019 04:08:27 by tbergmann

Hey all,

I am using Power Automate to take a request from a SharePoint list I have created (using it as a request form) and I have flows in place to create a file folder in a document library based on the information provided in the list. In this scenario, the 'Topic' entered into the list is what I want to be the name of the folder it creates for me.

I recently ran into a problem with the flow, however, relating to file folder names cannot end with a space, which is easy to accidentally do.

I need a way to take my 'Topic' input from the list, trim the whitespace/extra spaces from the end of the string and pass that over to the 'Create a Folder' action, to ensure the action doesn't fail due to invalid filename/syntax. I'm sure there's a way to code it, I just can't figure it out. (I've been using Power Animate for a week, not much coding experience)

Appreciative of any thoughts/ideas! Image below for reference in case my description doesn't make sense.

Flow post pic.png

All responses (2)

Answers (2)

Verified answer

v-bacao-msft on 13 Dec 2019 at 06:45:45

Like (1)

Report

Re: Removing trailing spaces (Trim?) from dynamic content

Hi @tbergmann ,

As @efialttes suggested, you could refer to this configuration:

Best Regards,
Verified answer

efialttes 14,756 on 13 Dec 2019 at 04:41:40

Like (0)

Report

Re: Removing trailing spaces (Trim?) from dynamic content

Hi
You can do it by defining an expression
https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

There is a WDL function called 'trim'
https://docs.microsoft.com/bs-latn-ba/azure/logic-apps/workflow-definition-language-functions-reference#trim
Hope this helps