Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Special characters or inline functions

(0) ShareShare
ReportReport
Posted on by 14

Hello,

  I am trying to do a simple flow to take email attachments and create them in a sharpoint file directory.  I need to use the email subject as the file name but they contain a colon which is an invalid character.  Is there any way to search and replace when creating the file name in the flow?

 


Thanks

Andrew

 

Categories:
  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    When you  type the input value in compose use double quotes (") at the beginning and end.

     

    e.g: "@concat(outputs('filename'),outputs('fname'))"

     

    Once you save the flow and go back to edit it should disappear the doubles quotes and it should be non-editable. Probably the non-editing part is a bug :-).

     

    Let me know how it goes.

     

    Thanks

  • andrewr Profile Picture
    andrewr 14 on at
    Re: Special characters or inline functions

    The compose steps don't seem to be executing....as you can see in the screen shot it's trying to pass the code from the compose step as the file name

     snip.PNG

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    This is documentation you need https://docs.microsoft.com/en-us/rest/api/logic/definition-language

     

    Please follow the below flow for your requirement.

     

    p1.pngp2.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    p3.png 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    If you need anymore help please let me know.

     

    Thanks

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    This is documentation you need https://docs.microsoft.com/en-us/rest/api/logic/definition-language

     

    Please follow the below flow for your requirement.

     

     

  • andrewr Profile Picture
    andrewr 14 on at
    Re: Special characters or inline functions

    Are there details of the concat fucntion?  I haven't been able to find it via a search

     

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    You need to do the following:

     

    1. Add another compose and map the input parameter as Attachment Name.

    2. Use the concat function to get together this output & subject.

     

    Thanks

  • andrewr Profile Picture
    andrewr 14 on at
    Re: Special characters or inline functions

    I need the file name to be the subject of the email, but I wonder if I can concatenate the original file name too.  Any thoughts?

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    I haven't tested with multiple. It should work if you using the actual filename. As you can see the flow SP template (See above) is in a loop.

     

    Thanks

  • andrewr Profile Picture
    andrewr 14 on at
    Re: Special characters or inline functions

    Thanks, this is really helpful.

     

    I'm just wondering if there is more than one attachment will it fail?

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Special characters or inline functions

    Hi @andrewr,

     

    You need to use Compose and utilise the workflow definition language function called replace.This is what you want.

     

    https://docs.microsoft.com/en-us/rest/api/logic/definition-language

     

    My Flow configuration:

     

    s1.png

     

     

    s2.png

     

    My Flow Test Result:

     

    s3.png

     

    Email Send with Attachmen and Subject as 'TestDoc:Aj'

     

    s4.png

     

    SharePoint File uploaded without colons.

    s5.png

     

     

     

     

     

     

     

    If you need any more help please let me know.

     

    Thanks

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics