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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LilayLily1

I would request you to share the required screenshots.

Thanks

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

substring or slice should do the work.

Was this reply helpful? Yes No
LilayLily1 4 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the value of
triggerBody()?['Attachments']?[0]?['Name']

Was this reply helpful? Yes No
LilayLily1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Where can I find it out?

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No