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)
Solved! Go to 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'],'.'))"
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'],'.'))"
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
48 | |
18 | |
14 | |
12 | |
11 |
User | Count |
---|---|
59 | |
41 | |
24 | |
20 | |
19 |