Rule not working when condition has been met when creating a list entry via grid view

Harry N Nomikos 1,246 Reputation points

Hi Team I've created a rule in a modern SharePoint list to notify myself and a few others in the team when the field is set to "Yes" When creating entries via grid view, it doesn't seem to trigger the rule to notify us, however when in the form and we change the field to "Yes", the rule works. Is there any reason why the rule doesn't work when in creating a List entry in grid view?


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,889 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.
525 questions
0 comments No comments
{count} votes

Accepted answer
  1. AllenXu-MSFT 16,871 Reputation points Microsoft Vendor

    Hi @Harry N Nomikos,

    Is your rule like the screenshot below?

    User's image

    If yes, adding a new item under grid view won't trigger the rule. This is by design because the trigger of the rule is "a column value changes" which the rule can only be triggered if the user changes the field value of an existing item. Creating items does not belong to changing item. That's why creating items and set the field value to "Yes" didn't trigger the rule but editing in the EditForm successed.

    If you still want the team to be notified, you need to integrate your list with Power Automate flow.

    Build a flow like this (Set the trigger of this flow to When an item is created or modified):

    User's image

    I also received the email after creating an item under grid view.

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful