Deleting JPG File in a Photo Library Error

[mtagliaferri]

I have a flow that needs to delete a .jpg file from a sharepoint library, this library is a photo library.

I am trying to delete via the name of the file.

I thought initially I needed to ge File properties but I cannot find the folder using this action, therefore I am using directly a delete

The File identifier returns the exact name of the file in the library.

When running the flow I get an error 'The response is not in a JSON format'

[v-duann-msft]

Hi @mtagliaferri 

Thank you for posting.

According to your description, you would like to delete file for dynamic files but currently got file not found error.

Because when delete file will send an HTTP request to SharePoint, so the Identifier of the file should encode to URL format, so you should replace these "/" to "%2F". So you could use the replace() function to process the file path, for example:

Hope the content above may help you.

Best regards,

Anna

[mtagliaferri]

Hi @v-duann-msft ,

Thanks for your reply, I presume the first compose is to get the name of the file, in my case is a Name Surname (from people picker and Display Name), when I enter the Crew Member (Display Name) it pulls in a Aplly Each

I presume on Compose 2 of your example I had to replace Hub with my file path:

I receive the below error when trying to save the flow:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Compose_2' at line '1 and column '16525' is invalid. Action 'Apply_to_each_2' must be a parent 'foreach' scope of action 'Compose_2' to be referenced by 'repeatItems' or 'items' functions.'.'.

[v-duann-msft · Accepted solution]

Hi @mtagliaferri 

Thank you for your attempts.

After checking your screenshot, I found the configuration in 'compose2' may have some problem. We need to use output from compose inside.

Here is the detailed example for your reference:

My list to store user account:

My folder to store user photo:

The flow should be:

outputs('Compose')
replace(outputs('Compose_2'),'/','%2F')

Once tested, I'm able to remove according photos and get successful result.

Hope it helps

Best regards,

Anna

[mtagliaferri]

@v-duann-msftThanks for your help, problem solved 😊