Answered

Power Automate FIle Name Extract

(0) Share

Report

Posted on by RR-05041550-0

Hello,

I am a new PAD user. I am trying to build a flow that will extract first 5 character of the file name from a folder and then match the 5 char with an excel file column a and if finds match it will rename it using column c. But I am having trouble make it to work.

I also tried this

for some reason %TextList[0]% is not doing anything. Can someone please help

Categories:

Power Automate Desktop

I have the same question (0)

All responses (22)

Answers (2)

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rrahat93

You have created your desktop flow with power fx enabled features since it's in-preview stage and it have lot of limitations as well.

Please find the below known limitations for power fx enabled flow.

Please replicate your desktop flow by deactivating that option as shown below, and implement similar logic, it should work properly
.

In case if you want to continue with power fx enabled flow with known limitations then use the below syntax:

Index starts from 1 in power fx

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
RR-05041550-0 74 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji if i change I disable power FX, do you think my flow will work?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rrahat93

In case if you want to continue with power fx enabled flow with known limitations then use the below syntax:

Index starts from 1 in power fx

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
RR-05041550-0 74 on at

Like (0)

Report
Copy link

Link copied!

I rebuilt it and disabled power fx. but file name are not changing.
my file name is in this format 00023_2024-MAR-U002K3Q4

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @rrahat93 ,

Please find the solution. Please Disable the Power FX option before creating the flow.

Code:

System.TerminateProcess.TerminateProcessByName ProcessName: $'''EXCEL''' Folder.GetFiles Folder: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Excel\\Excel Input''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files LOOP FOREACH CurrentItem IN Files Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: CurrentItem.FullName Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''A''' StartRow: 1 ReadAsText: False CellValue=> A_ColumValue Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''C''' StartRow: 1 ReadAsText: False CellValue=> C_ColumnValue Excel.CloseExcel.Close Instance: ExcelInstance SET FileName TO CurrentItem.NameWithoutExtension Text.SplitText.SplitAtNumberOfCharacters Text: FileName SplitInterval: 5 Result=> Five_FileName SET First_Five_FileName TO Five_FileName[0] Text.Trim Text: First_Five_FileName TrimOption: Text.TrimOption.Both TrimmedText=> First_Five_FileName IF First_Five_FileName = A_ColumValue THEN File.RenameFiles.Rename Files: CurrentItem.FullName NewName: C_ColumnValue KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles END END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rrahat93

How is your folder files and excel files looks like?

Share some screenshot on the same.

Was this reply helpful? Yes No
RR-05041550-0 74 on at

Like (0)

Report
Copy link

Link copied!

NewVar Variable is giving this

Was this reply helpful? Yes No
RR-05041550-0 74 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @rrahat93 ,

Try My solution and let me know.

Regards,
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@rrahat93

Do you intend to truncate the filename obtained from the folder, verify if the truncated filename exists in column A, and if there's a match, extract the corresponding name from column C to rename your file accordingly? Is this the workflow you wish to create?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No