How to configure to only trigger the flow if send approval='YES'

NewLearner 20 Reputation points
2023-05-10T07:14:23.9+00:00

Good day,

I have a list that have the column 'Send Approval?' that has the setting as below:

User's image

and the flow that I am working on is to continue the flow only if 'Send Approval?' is equal to 'YES'. I have tried to setup a condition after an automated triggering: but failed

User's image

I also tried to add a trigger condition in the 'When an item is created or modified' setting: again it failed.

User's image

Can anyone please help me?

thank you

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

Answer accepted by question author
  1. Xyza Xue_MSFT 30,241 Reputation points Microsoft External Staff
    2023-05-10T09:35:54.8266667+00:00

    Hi @NewLearner ,

    I tested your problem, and I found that the reason for the failure is because the column name contains the symbol "?".

    When I create a choice column named "Send Approval", I use the trigger condition in the 'When an item is created or modified' setting, and it works fine.

    @equals(triggerBody()?['Send Approval']?['value'],'Yes')  
    
    

    User's image

    When I create a choice column named "Send Approval?", No matter how I change the trigger condition in the 'When an item is created or modified' setting. Flow will not be triggered.

    And if I change the column name and delete "?", it has no effect, maybe its internal name cannot be modified. I suggest you re-create a choice column name without "?", try to tell me the result, please?

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.