Answered

SharePoint Library File Content Approval Status Change not triggering flow

(0) Share

Report

Posted on by MP-20111946-0

Hi,

I have a sharepoint library with content approval enabled. I want a flow to trigger when a file is changed to Approved status.

I am using this trigger condition : @equals(triggerOutputs()?['body/_ModerationStatus'], 'Approved'), but no joy.....

I have also tried these conditions : @equals(triggerOutputs()?['body/ModerationStatus'], 'Approved') & @equals(triggerOutputs()?['body/ModerationStatus'], '0')

But I cant get the trigger to work when I approve a file in the librbary.

Anyone have any ideas? suggestion on what I can do to test or troubleshoot, as I am out of ideas and cant seem to find anything on the googler...

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

MP-20111946-0 21 on at

Like (2)

Report

I think I figured it out.

I had the check in/out enabled. when I disabled check in/out, I was able to get the trigger to run using the status "Pending". I assume this was because you cant edit a file thats checked in already...

Was this reply helpful? Yes No
MP-20111946-0 21 on at

Like (0)

Report

I am back stuck with this trigger command again. Check in is disable.

I had it working but lost the trigger action code and now I cant find teh right one again. I have tried the following and no joy. any suggestions or ideas?

@equals(triggerOutputs()?['body/_ModerationStatus'], 'Draft')
@equals(triggerOutputs()?['body/ModerationStatus'], '3')
@equals(triggerOutputs()?['body/ModerationStatus'], 'Draft')
@equals(triggerOutputs()?['body/OData__ModerationStatus'], 'Draft')

Was this reply helpful? Yes No
Suggested answer

MP-20111946-0 21 on at

Like (0)

Report

Figured it out... eventually.

I needed to remove the body/ from the code: @equals(triggerOutputs()?['body/{ModerationStatus}'], 'Draft').

This is what worked: @equals(string(triggerBody()?['{ModerationStatus}']), 'Draft')

Was this reply helpful? Yes No