Answered

Flow to move file upon 'approval'

(0) Share

Report

Posted on by tomh

159

Hello all, I know there is a way to do what I'm trying to do and I'm still looking for a solution! There must be a better way!

I have a flow that is triggered when file is created or modified in a SP doc lib. It checks to see if 'Content Approval Status' = Denied. If yes then the file is moved to a different folder. Problem: The flow triggers and action triggers before the approval process is complete and thus always returns a 'false' value. Apparently the flow is not retriggered upon the metadata being updated and the 'content approval' being set to denied.

Looking into 'Do Until' control. Another user recommended using a delay command and that works fine but don't have enough control of this function. Need to utilize a do until or some sort of loop command that continues to check the 'content approval' column until the is a value of either 'approved' or 'denied' and wait/do nothing if 'draft' or 'in process'.

Can anyone help here and thanks so much in advance!

Current flow attached.

Tom

Flow 1.PNG Flow 2.PNG

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

tomh 159 on at

Like (0)

Report

I've updated my flow and have everything working accept for the 'do until' function. It won't quit! Even when the parameters are satisfied. However, need help now writing the expression to accommodate an or statement for the 'Content Approval Status' field.

Currently the function reads: Do until-'Content Approval Status' CONTAINS Denied
and looking to write:
Do until-'Content Approval Status' CONTAINS Denied or Approve

Thanks all!

Tom

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @tomh ,

Please try this expression:

@equals(or(contains(body('Get_file_properties')?['{ModerationStatus}'], 'Denied'), contains(body('Get_file_properties')?['{ModerationStatus}'], 'Approved')), true)

Best Regards,

Was this reply helpful? Yes No