Hello,
I'm facing one issue in Power Automate while I try to run a flow with the Dataverse trigger 'When a row is added, modified or deleted'
I have an app, within it has a simple form with some information and attachments columns connected to Dataverse, to submit this Form I'm using a SubmitForm() action in the button, as the picture bellow:
The problem is:
When I create a new row inserting attachments into these attachments columns, the flow runs more than once.... it runs the first time with the SDKMessage "Create" and with no attachments, and more X time according the attachments with the SDKMessage "Update"...
But it should be running just once as the ideia is the row just being created and not updated
I use a TriggerOption to check the Status, if is "Pending" as I can save it fisrt as "Draft" and after Save and Send.
Also, I tried to add into 'Delay Until' a formula to add 2 minutes to the utcNow() to wait but it never triggered again....
I don't even know how to make a question different from "Why this is happening?" as my point of view it should be running after the row is fully created, in other words, it should wait until all the columns that were sent by the SubmitForm were filled to then start the 'Create' flow.
Have anyone passed trought it? How and what can I do to make it works in a smart way instead of add conditions to verify if the attachments were created 'cause they are not required and it's possible to have 4 of them!?
All the help is appreciated!