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

Categories:

Using connectors

I have the same question (0)

All responses (16)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (1)

Report

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

In ft_img_prodottoid field exists a GUID value

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (0)

Report
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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (1)

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

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (1)

Report

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @David_Pezzoli

I made a tutorial video about this

Please have a look

https://youtu.be/WZRE0o4-pH8

Thanks

Was this reply helpful? Yes No