Forum Discussion

paulhaigh's avatar
paulhaigh
Copper Contributor
Jun 09, 2022

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's avatar
    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?

     

paulhaigh's avatar
paulhaigh
Copper Contributor

Here's my flow:

 

 

RobElliott's avatar
RobElliott
Silver Contributor
Jun 13, 2022

paulhaigh the action is showing the normal fields and is not missing anything. If you want to use any of the columns for a later action add a Compose action between the trigger and the get changes action.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Resources