Unanswered

Parse portion of Email Attachment File name to look up SharePoint List

(0) Share

Report

Posted on by jknecht

I'm fairly new to Power Automate and haven't been able to figure out how to do the following:

Email comes in with an attachment, I need to forward the email and attachment to a specific distribution group based on the first portion of the attachment's file name. The list of all the distribution groups are in a SharePoint List. I just don't know how to parse the attachment's file name so it can be used to look up the distribution group's email address. Example of a file name:

Shaws-Inventory_May 2020

Shaws is the identifier on my list and the distribution email connected with it will be used in the email that gets forwarded.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Assuming that the filenames are always in the form of Identifier followed by a '-' you can simply do a split() of the filename based on the '-' character. Then the identifier will be the first entry in the resulting array.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Well you could write an expression to find the first "-" character, the extract the portion of the string upto, but not including that position. Use Compose action with substring and indexof.

Or

You could use the split expression, which returns an array of strings with each element being a part of the split:

eg: split ( 'abc-def-ghijk','-') => ['abd', 'def', 'ghijk'] then take only the first element into your variable.

Was this reply helpful? Yes No