Remove user names on uploading files

[benidoink]

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.

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

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"

        ]

    }

}

[ekarim2020 · Accepted solution]

Here is an expression that might do the trick:

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

Ellis

[benidoink]

Hi @ekarim2020 

It worked sir. thank you so much 🙂

[ekarim2020]

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