Answered

Sent email when a new folder is created

(0) Share

Report

Posted on by 72Zib

Hi,

is there a way to send an email when a new folder is created on a SharePoint the folder name is a part of the email address,

Tha folder name is a number that can be 1 to 4 digits, for example for folder 12 email address would have format like EDU0012@edu.cbc

Thanks

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

Hi @72Zib ,

Please refer to my post here.

There may be an easier way but you could use an if() expression to check the length() of the folder name. If 1, then concat() 000, If 2, then concat() 00 etc. Will be a pretty long expression.

You could also use conditions or a switch statement.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
72Zib 68 on at

Like (0)

Report
Copy link

Link copied!

is there a way to make the folder name to be always 4 digits like 66 be converted to 0066?

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @72Zib ,

Sure.

Use the concat() expression and replace xxxx with the name from your trigger

@concat('EDU',triggerOutputs()?['body/{Name}'],'@edu.cbc'

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
72Zib 68 on at

Like (0)

Report
Copy link

Link copied!

Thanks,

Is there a way to convert the folder name to the format i need and use that name as email address?

Tha folder name is a number that can be 1 to 4 digits, for example for folder 12 email address would have format like EDU0012@edu.cbc

Thanks

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @72Zib ,

You can use the when a file is created trigger and the IsFolder property.

It will return true if its a folder

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No