How to create a PowerAutomate which will be triggered on created/modifed metadata of a document?

[KLD]

I would like to create a PowerAutomate which needs to be triggered on created/modified metadata of a document. I dont want the PowerAutomate will be triggered when I modify the content of a Word document and auto-save is on. When auto-save is on in Word it will trigger each auto save the PowerAutomate. It costs me to much api requests from my license.

[tom_riha · Accepted solution]

Hello @KLD ,

if the document library has only a small amount of metadata, you could create 'hidden' column for each of them and keep them synchronized. That way you could add a trigger condition that would check if the data in both of the columns (the main one and the hidden one) is the same and run only if it's different (and synchronize them again).

Below is an example of a trigger condition using 2 such metadata columns:

@or(not(equals(triggerOutputs()?['body/Column1'],triggerOutputs()?['body/Column1_copy'])),not(equals(triggerOutputs()?['body/Column2'],triggerOutputs()?['body/Column2_copy'])))

more readable format:
@or(
    not(equals(triggerOutputs()?['body/Column1'],triggerOutputs()?['body/Column1_copy'])),
    not(equals(triggerOutputs()?['body/Column2'],triggerOutputs()?['body/Column2_copy']))
)

But if it's many metadata columns then the solution could get quite complicated.