Folder name in letter body (like file name)

(0) Share

Report

Posted on 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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Nicolas_P 19 on at

Like (0)

Report
Copy link

Link copied!

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
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

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