MS Dataverse How to delete image field row with Power Automate

(0) Share

Report

Posted on by David Pezzoli

230

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:

2022-04-13 10_35_39-OneNote for Windows 10.png

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.com)

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??

All responses (16)

Answers (1)

abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: MS Dataverse How to delete image field row with Power Automate

Hi @Gprior

Could you please create a new thread and post a screenshot of your flow?

Thanks
Gprior 167 on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate

Hello @abm
thank you for your support so far!

I'm trying to copy the image from one image column in one entity to another image column in another entity in order to sync data between two model driven apps used by two different teams here in my company.

The destination field is read only (i.e. the team A upload a picture in a model driven app and saves, then a flow is triggered and the image must be copied into the image column of another entity used by a different model driven app used by team B which should not change the image).

Also when team A changes the image, i have to delete and upload again the new image in the destination entity.

I'm having two different problems: the first is that i'm not able to upload picture the first time when i'm creating the record in the destination entity; the second is that once i tried to update it with a new image i'm not able to gain authorization even if i'm taking correctly the token from Azure.
Can you help?

Thank you for any support!
abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate

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
FU Microsoft 112 on at

Like (0)

Report

Re: MS Dataverse How to delete image field row with Power Automate

Same problem here. And none of the proposed solutions in this thread work.
FU Microsoft 112 on at

Like (0)

Report

Re: MS Dataverse How to delete image field row with Power Automate

The steps in your tutorial do not work. The file is never found when using the DeleteFile unbound action.
David Pezzoli 230 on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate

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

abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate

Hi @David_Pezzoli

I made a tutorial video about this

Please have a look

https://youtu.be/WZRE0o4-pH8

Thanks
abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate

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
David Pezzoli 230 on at

Like (1)

Report

Re: MS Dataverse How to delete image field row with Power Automate
David Pezzoli 230 on at

Like (1)

Report
Re: MS Dataverse How to delete image field row with Power Automate

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