How to get =LEFT(Filename,SEARCH(".",Filename)-1) to work sharepoint update action?

[martinav]

I need this command to use the front part of a filename into a field.  I need this to occur during item creation.  It works fine as a calculated value in Sharepoint, but I need that field to be a text field after initial creation.  It would be great to do this in flow.  There does not seem to be a set of "Expression" commands to emulate this statement.

=LEFT(Filename,SEARCH(".",Filename)-1)

[martinav · Accepted solution]

I found this in a similar post.  For my purpose, this is what worked... finally.

"@substring(body('Get_file_properties')?['Filename'],0,lastindexof(body('Get_file_properties')?['Filename'],'.'))"