Missing columns in "Get changes for an item or a file"

Hi all, I'm trying to trigger a flow when the OOTB 'approval' process sets a document to 'Approved'. I've got a flow that triggers on file changes (it's a doclibrary) and that's fine, but the c...

Microsoft Flow

sharepoint

racrig
Jun 13, 2022
paulhaigh
I did a test and I also do not see the approval status field available in the Has Column Changed set of available columns. It's tricky because in other areas, it's titled Content Approval Status, and of course the internal name of that column is actually ModerationStatus. See:

I have a workflow that does not use the Get Changes method, but instead just puts a trigger condition on the first action "When a file is created or modified". The condition is:

@equals(triggerBody()?['{ModerationStatus}'],'Approved')

Maybe you could accomplish what you need this way?

racrig

Brass Contributor

Jun 13, 2022

paulhaigh

I did a test and I also do not see the approval status field available in the Has Column Changed set of available columns. It's tricky because in other areas, it's titled Content Approval Status, and of course the internal name of that column is actually ModerationStatus. See:

I have a workflow that does not use the Get Changes method, but instead just puts a trigger condition on the first action "When a file is created or modified". The condition is:

@equals(triggerBody()?['{ModerationStatus}'],'Approved')

Maybe you could accomplish what you need this way?

paulhaigh

Copper Contributor

Jun 14, 2022

racrig Yes, I ended up doing something like that too, which works much better than a Get Change -> Condition anyway!

Forum Discussion

Missing columns in "Get changes for an item or a file"

Resources