web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tGLyZ43CO5/auwfkUc69NS
Power Automate - Building Flows
Answered

Sending reminder email until SharePoint list item field value not null

Like (0) ShareShare
ReportReport
Posted on 11 May 2020 05:12:46 by

Hi,

 

I trying to send a reminder email to user to fill up a Microsoft form, this reminder will be repeatedly sent until user has completed the form and the SharePoint list item value has been updated with the value, becoming not null.

 

I having issue writing the condition for Do Until Action. What I intended is to firstly check the validation for the same unique ID (Employee ID), in the form and SharePoint. Second item to check is the entry in the SharePoint with the same unique ID whether the other field is still empty, in this case, Email group field.

 

The current condition I have come up with, which is not correct. As it still continue to sent reminder email even after the field is not longer empty. Or is there something I'm missing.

@And(equals(body('Get_response_details')?['r977e392e5f9d406abd8044a638c8ab80'], items('Apply_to_each')?['Staff_x0020_ID']), not(equals(items('Apply_to_each')?['Email_x0020_group'], '')))

 

flow.PNGsharepoint.PNG

 

 

Thanks in advance.

  • Verified answer
    v-bacao-msft Profile Picture
    on 14 May 2020 at 05:44:30
    Re: Sending reminder email until SharePoint list item field value not null

     

    Hi @Anonymous ,

     

    Maybe you could create two flows to achieve your needs.

     

    One Flow is to get the response from the form, and get the item by the employee ID and update the item through the submission.

    One Flow is to check if the specified field is empty, as @sudharsan1985 suggested, use Recurrence as the trigger and check all items.

     

    If the specified is empty, send a notification to the user to fill the form.

     

    Hope this helps.

     

    Best Regards,

  • sudharsan1985 Profile Picture
    1,325 on 11 May 2020 at 07:35:31
    Re: Sending reminder email until SharePoint list item field value not null

    @Anonymous 

    Since this form is not tied to any user, then you can directly send the link in the scheduler rite. If you still insists on using this method, then I need to check how the 'Do Until' works. Maybe what you can do is store each individual value that is used for condition in a separate variable.

     

    Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
    -Sudharsan K...

  • Community Power Platform Member Profile Picture
    on 11 May 2020 at 07:21:49
    Re: Sending reminder email until SharePoint list item field value not null

    @sudharsan1985 

     

    Thanks for the advise, but would it be possible to continue using this method?

     

    Reason being this Form is an URL link and is not tied to the person. This link is sent via email for the user to fill up.

     

     

  • sudharsan1985 Profile Picture
    1,325 on 11 May 2020 at 06:13:37
    Re: Sending reminder email until SharePoint list item field value not null

    @Anonymous 

    Can you try using the 'Scheduler Flow' so that you don't have to make the flow wait. Usually the reminder emails are sent on a daily basis which can easily achieved using the 'Scheduler Flow'. Moreover you can check all the users whoever hasn't submitted the form and send them an email to all of them.

     

    Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
    -Sudharsan K...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete