Extract charactes from attached file name

(0) Share

Report

Posted on by LilayLily1

Hello together,

I'm trying to create a flow which get daily email from a shared outlook mailbox at a specific time and save the attached file in a sharepoint. The attached file name is, for example, 23_05_15_XX.xlsx. I would like to extract 23_05 (YY_MM). I have a problem with extracting the five characters of the attached filed name. If necessary, I will provide you with screenshots.

Thank you for your help

All responses (6)

Answers (0)

Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Extract charactes from attached file name

Look into the flow history trigger or create a compose action where you put the dynamic value or formula.
LilayLily1 4 on at

Like (0)

Report

Re: Extract charactes from attached file name

Where can I find it out?
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Extract charactes from attached file name

What is the value of
triggerBody()?['Attachments']?[0]?['Name']
LilayLily1 4 on at

Like (0)

Report
Re: Extract charactes from attached file name

Hello,
thanks for your answer. I've already tried substring
substring(triggerBody()?['Attachments']?[0]?['Name'],0,6
. But I get an error. Power Automate is expecting an array and not an object.
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Extract charactes from attached file name

Hello,

substring or slice should do the work.
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Extract charactes from attached file name

Hi @LilayLily1

I would request you to share the required screenshots.

Thanks