cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
agneum
Advocate IV
Advocate IV

Combining functions with dynamic expressions - very painful

I have a super simple flow:

When a new email arrives -> Apply to each attachment -> Create file (sharepoint)

In the last step I want to place the attachment in the folder based on the attachment filename.
The filename will include underscore. Everything to the left of the underscore will be the folder name in which I want the file placed.

When I try using the split function with the expression for the file name, it doesn't work. Clicking split, and then going to the "dynamic fields" tab, doesn't even show me the option to select the file name. And here I thought file names were strings? What is the issue here?

Furthermore I've noticed I have to hold down "command" key on my mac when switching between the tabs,
i.e. I first have to click the "split" function, then write the first opening brace "(" which will also include an end brace. Then I have to hold down "cmd" key on the mac, switch tabs and click on a dynamic field (If I'm lucky it's even there). If I don't do the last steps the expression just vanishes and I have to start from scratch.

If I just copy the field, I get a lot of giberish with @ signs and curly braces:

split(@{items('Apply_to_each')?['name']},'_')

The correct string should be:
split(items('Apply_to_each')?['name'],'_')

The user experience needless to say when it comes to dynamic fields is very frustrating, and not user friendly. I've seen tons of threads mentioning functions and dynamic expressions, most of which would easily be solved with a better UI/UX experience.

0 REPLIES 0

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (61,361)