Unanswered

Special characters or inline functions

(0) Share

Report

Posted on by andrewr

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:

Using connectors

I have the same question (0)

All responses (13)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @andrewr,

This is what you want.

My Flow configuration:

Was this reply helpful? Yes No
andrewr 14 on at

Like (0)

Report
Copy link

Link copied!

Looks like the end of your message didn't come through 😕

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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:

My Flow Test Result:

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

SharePoint File uploaded without colons.

If you need any more help please let me know.

Thanks

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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:

My Flow Test Result:

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

SharePoint File uploaded without colons.

If you need any more help please let me know.

Thanks

Was this reply helpful? Yes No
andrewr 14 on at

Like (0)

Report
Copy link

Link copied!

Thanks, this is really helpful.

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
andrewr 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
andrewr 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No