Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Remove user names on uploading files

(0) ShareShare
ReportReport
Posted on by 73

Hi Guys,

I use MS Forms to upload files and Power Automate to move the file from the Forms database which is OneDrive to Sharepoint Site. It works very well my question is that there is a chance to remove user names on uploading files? See below the screenshot from my SharePoint site, looking at the picture, the file name becomes "Sample Scan (100,ppi)_Benedick Divinaflor" it should be "Sample Scan (100,ppi)" ". 
Lastly, we upload multiple files per Form.

benidoink_0-1630595720014.png
Here's my Flow, if you notice on the File Name under Created File, I am using Parse JSON to get the file name. 

benidoink_1-1630596346421.png

And here's my Parse JSON schema I used.

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "name": {
                "type""string"
            },
            "link": {
                "type""string"
            },
            "id": {
                "type""string"
            },
            "type": {},
            "size": {
                "type""integer"
            },
            "referenceId": {
                "type""string"
            },
            "driveId": {
                "type""string"
            },
            "status": {
                "type""integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

 

  • BlueMoon1124 Profile Picture
    14 on at
    Re: Remove user names on uploading files

    Thank you so much! This helped me with my concern as well. 🙂

  • Ellis Karim Profile Picture
    10,923 Super User 2025 Season 1 on at
    Re: Remove user names on uploading files

    In case anyone is interested, a breakdown of the expression:

    ekarim2020_0-1630602489405.png

     

  • benidoink Profile Picture
    73 on at
    Re: Remove user names on uploading files

    Hi @ekarim2020 

    It worked sir. thank you so much 🙂

  • Verified answer
    Ellis Karim Profile Picture
    10,923 Super User 2025 Season 1 on at
    Re: Remove user names on uploading files

    Here is an expression that might do the trick:

    ekarim2020_0-1630599115180.png

    concat(first(split(outputs('name'),'_')),'.',Last(split(last(split(outputs('name'),'_')),'.')))

    ekarim2020_1-1630599208974.png

    Ellis

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow