Folder name in letter body (like file name)

Like (0) Share

Report

Posted on 1 Apr 2020 12:05:26 by Nicolas_P

Hello community!

Need your help.

I create a flow (when i'm upload the new file to Sharepoint - automaticly sending e-mail to user).

In letter bodu i add file name via

@{triggerBody()?['{FilenameWithExtension}']}

Also i'm add the

@{triggerBody()?['{Path}']}\n, but from path i need only the folder name (files location).

Can you help with this?

Regards, Nicholas.

Categories:

Dataflows

I have the same question (0)

All responses (6)

Answers (1)

Nicolas_P 19 on 15 Jul 2021 at 12:04:31

Like (0)

Report

Re: Folder name in letter body (like file name)

Dear Sik!

Man thx for your help, i'm doing the correct for your instruction and all is working great!

One question - is it possible to make a trigger not for one files added? If i'm add the two or more files with few minutes delays, can the all of filenames and paths be in one letter?

Regards, Nicolas.

Was this reply helpful? Yes No
v-siky-msft on 03 Apr 2020 at 07:42:27

Like (0)

Report

Re: Folder name in letter body (like file name)

Hi @Nicolas_P ,

OK. I got you. The issue is from last(body('Filter_array')) expression in email body.
You have to replace the 'Filter_array' by the real localized name of 'Filter Array' action
Hope this helps.
Sik

Was this reply helpful? Yes No
Nicolas_P 19 on 03 Apr 2020 at 07:23:52

Like (0)

Report

Re: Folder name in letter body (like file name)

@v-siky-msft hello!

I'll do all step by step on your advice, really.
Maybe some problem on Options "Send_an_email"?

Regards, Nicolas.

step_1.png

error.png

step_2.png

Was this reply helpful? Yes No
v-siky-msft on 03 Apr 2020 at 01:17:35

Like (0)

Report

Re: Folder name in letter body (like file name)

Hi @Nicolas_P

Where did the error occur?
Please post the detailed flow steps and expressions, this helps us to analyze the problem.
Sik

Was this reply helpful? Yes No
Nicolas_P 19 on 02 Apr 2020 at 11:55:27

Like (0)

Report

Re: Folder name in letter body (like file name)

Hello @v-siky-msft !

Many thx for your answer, i'm doing step by step as your instruction, but there are next mistake:
Please correct to add a valid "Filter_array" link for the original "Send_an_email"...(

Was this reply helpful? Yes No
Verified answer

v-siky-msft on 02 Apr 2020 at 09:29:40

Like (0)

Report

Re: Folder name in letter body (like file name)

Hi @Nicolas_P ,
You just want to get the name of the file's parent folder, right?
Add a Filter Array action before sending an email as below:
1. Set From field as below, the split will split the text based on specified delimiter character, and return an array.
split(triggerBody()?['{Path}'],'/')
2. Click Edit in Advanced Mode, input: @equals(empty(Item()),false) to filter out empty item in array.
3. in the email body, use last(body('Filter_array')) expression to get the file's parent folder name.
Sik

Was this reply helpful? Yes No