MS Dataverse How to delete image field row with Power Automate

[David_Pezzoli]

Hi all,

I want to delete, automatically with a Power Automate flow, the image file content  attached to the Image field on my Dataverse QuoteDetail form:

 

I try with Dataverse unbound action "DeleteFile" as mentioned in these following links:

Solved: Deleting image/file from CDS image/file field with... - Power Platform Community (microsoft....

https://linnzawwin.blogspot.com/2020/09/move-attachment-from-file-field-of.html#InitializeVariables

But the action step "DeleteFile" occur this error 'fileattachment With Id = '...GUID value...' Does Not Exist"'.

I passed to the action step the file Id ("ft_img_prodottoid" attribute) but the action always occurs the error above.

How can I delete the content of the image field using Power Automate cloud flow, please??

[v-xiaochen-msft]

Hi @David_Pezzoli ,

What's your trigger?

Could you click the flow run history and check the value of ft_img_prodottoid?

In your ft_img_prodottoid field , does this value exist?

Best Regards,

Wearsky

[abm]

Hi @David_Pezzoli 

Its a look up value so that contains the logic name and GUID. To get the GUID try the below

triggerOutputs()?['body/_ft_img_prodottoid_value']

Thanks

[David_Pezzoli]

My Trigger is Create & Update of Quote Product row (quotedetail)

About history:

In ft_img_prodottoid field exists a GUID value

[abm]

Hi @David_Pezzoli 

Thanks for your update. Could you go to CRM record and right click the lookup and open in a new window. Compare the Id from the url and run history.

Thanks

[David_Pezzoli]

Hi @abm ,

it isn't a Lookup field because:

• ft_img_prodotto is a image type field
• There is no _ft_img_prodottoid_value in JSON OData structure but only:

e.g.

"ft_img_prodotto": "iVBORw0KGgoAAAANSUhEUgAAAIoAAACKCAYAAAB1h9JkAAAAAXNSR0IArs4c6.........."

"ft_img_prodottoid": "dc5e9d1f-10bc-ec11-983f-000d3a659931"

"ft_img_prodotto_url": "/Image/download.aspx?Entity=quotedetail&Attribute=ft_img_prodotto&Id=d85e9d1f-10bc-ec11-983f-000d3a659931&Timestamp=637855506063018377"

"ft_img_prodotto_timestamp": 637855506063018400

[abm]

Hi   

Above id you are passing and it is getting the error. 

Could you pass this id below and see

d85e9d1f-10bc-ec11-983f-000d3a659931

.

Hardcode the value and test it. 

@David_Pezzoli

[David_Pezzoli]

Hi, After pass 

d85e9d1f-10bc-ec11-983f-000d3a659931

Occur Same error: fileattachment With Id = d85e9d1f-10bc-ec11-983f-000d3a659931 Does Not Exist

[David_Pezzoli]

[abm]

Hi @David_Pezzoli 

I have some answers for you. I did a quick test now.

If you have a file type then you can delete using the Ubound action step. In your case you have image data type which is stored in Azure blob storage. You can't directly delete via the connector. You need to use the HTTP API to delete the record.  Documentation doesn't says about delete. I will have a look on this and update you soon.

Image columns (Microsoft Dataverse) - Power Apps | Microsoft Docs

Thanks

[abm · Accepted solution]

Hi @David_Pezzoli 

I made a tutorial video about this

Please have a look

https://youtu.be/WZRE0o4-pH8

Thanks

[David_Pezzoli]

Wow! Very grateful for the video and the help!  Thanks for your time @abm 

[GringoInMiami]

The steps in your tutorial do not work. The file is never found when using the DeleteFile unbound action.

[GringoInMiami]

Same problem here. And none of the proposed solutions in this thread work.

[abm]

Hi @GringoInMiami 

Most likely your mapping is not quite and thats the reason file is never found. If you could post a screenshot of your flow I could look into this.

Thanks