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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,628 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
508 questions
0 comments No comments
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 19,636 Reputation points Microsoft Vendor
    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