Unanswered

Move multiple text files from Onedrive business to SharePoint and change filename last 10 characters

(0) Share

Report

Posted on by BandersonME

Hello, I am going to have 4 text files uploaded daily from a nightly SAP batch run. I'm trying to move these four files to a SharePoint folder and rename them by removing the last 10 characters from each of their filenames and I can't seem to get this to work.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @BandersonME

Try this approach

for name , try this expression :
concat(take(items('Apply_to_each')?['NameNoExt'],sub(length(items('Apply_to_each')?['NameNoExt']),10)),'.',split(items('Apply_to_each')?['Name'],'.')?[1])

This will ensure that file name doesn't contain last 10 characters while creating same file in sharepoint 🙂

Hope this helps
Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
BandersonME 6 on at

Like (0)

Report

@Nived_Nambiar it doesn't seem to be working. What are you using at the top of the flow above list of files in folder?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @BandersonME
I am using manually trigger flow at top before list of files in folder
May i know what error you are getting ?

Was this reply helpful? Yes No
BandersonME 6 on at

Like (0)

Report

@Nived_Nambiar I can create another request if needed, but how would I delete the original files from the Onedrive? If I add in a Delete File box under the Apply to All, it only deletes one. If I add Delete File "File Content" in the Apply to All, it errors out.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @BandersonME

Since create file action was showing error, so the delete file hasn't worked.

Was this reply helpful? Yes No