cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pandra
Level: Powered On

Listen for updates to SharePoint List

Hello,

 

I'm new to MS Flow and am quickly getting up to speed on things. Very impressive App. I've done workflows in SharePoint Designer, but this looks even better and easier.

 

OK, my question:

 

I have a Sharepoint list. I want to "listen" for when the list is updated, specifically when a certain field is marked "Yes",When that happens I want to alert the next department that they need to do certain tasks. 

 

I'm having a problem comfiguring this. I see a trigger for "...An item is created or updated". I added that, then a condition under that to basically say, "When this field changes to Yes, send an email to someone". After editing the list to mark that field Yes, an email is not being sent.

 

Just can't seem to get this to work. Any suggestions on this would be terrific.

 

thank you 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Hello Mabel,

 

thanks for the reply and your efforts to help us.

 

So this is how we look for changes when they happen. That's great to know...

 

I've tried to replicate this here but am getting an error before I can choose an action in the YES section:

 

I know I've got the correct Y/N checkbox field ID below, so it's not that.

 

Capture.PNG

 

To further describe the business need, we want to:

 

- Send an Email to a specific person when a new record is added. (Not shown here, but will add it later)

- Send an Email when the first department is finished - indicated by a checked box for that field. This will happen 3 times, one after another (3 departments). Would I just add another Condition after this one, once I get this one working?

 

Many thanks for you kind assistance!

 

Pandra

 

 

Super User
Super User

Re: Listen for updates to SharePoint List

Hi @Pandra.

 

This that you marked - Cannot read ... is a knew bug. 

 

Press CTRL + SHIFT + F5 to clean the cache and workaround this

 

I believe that flow staff are fixing this bug.

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


10 REPLIES 10
Community Support Team
Community Support Team

Re: Listen for updates to SharePoint List

Hi Pandra,

 

Not sure how is your flow created. Please take my flow configuration for a reference.


According to your description, I create a Yes/No column in my list.


I use the trigger “SharePoint – When an item is created or modified”, then I add a Condition to check if the certain field in the list has been changed to “Yes”.


If yes, send me a mobile notification. In your case, you could add the action “Send an email”.


Please check the following screenshot for the flow:

3.PNG

 

Reference documentation:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Hello Mabel,

 

thanks for the reply and your efforts to help us.

 

So this is how we look for changes when they happen. That's great to know...

 

I've tried to replicate this here but am getting an error before I can choose an action in the YES section:

 

I know I've got the correct Y/N checkbox field ID below, so it's not that.

 

Capture.PNG

 

To further describe the business need, we want to:

 

- Send an Email to a specific person when a new record is added. (Not shown here, but will add it later)

- Send an Email when the first department is finished - indicated by a checked box for that field. This will happen 3 times, one after another (3 departments). Would I just add another Condition after this one, once I get this one working?

 

Many thanks for you kind assistance!

 

Pandra

 

 

Super User
Super User

Re: Listen for updates to SharePoint List

Hi @Pandra.

 

This that you marked - Cannot read ... is a knew bug. 

 

Press CTRL + SHIFT + F5 to clean the cache and workaround this

 

I believe that flow staff are fixing this bug.

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Gustavo, thanks for this!

 

 

Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

One other minor issue with this:

 

First of all, this is working - I'm able to send notification emails as intended. The thing is, since this is looking for ANY change, the first department is being notified again when the second department is notified

 

Capture2.PNG

 

The HR email goes out again when it's time to send out the IT Email. 

 

Is there any way to prevent this? I could separate them as separate workflows I guess, but it would be nice to have it as one.

 

Thanks!

Super User
Super User

Re: Listen for updates to SharePoint List

Hi @Pandra.

 

When i have to do something like this, i create a column in SharePoint called 'InProgress', when i start my flow i check if th Column value is 'false', if yes i set it with 'true' and do my actions - when i change other flow is started, but it no pass in condiction.

 

For this you'll need to use the Terminate action.

 

If you need more help, you're welcome to ask Smiley Happy

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Gustavo, thank you....

 

If I'm understanding correctly, I would:

 

  • Add an InProgress column for each department defaulting to False 
  • Have Flow set it to True then complete the Email notification for that department
  • Set it back to False when complete
  • Repeat for next department

If so, where would the Terminate action go?

 

Thanks!

 

 

Super User
Super User

Re: Listen for updates to SharePoint List

HI @Pandra

 

No need one column for each, only one, when an item start the flow it should go to all steps. The condiction will be the first action in our flow, below the trigger, if  'InProgress' = true send to a Terminate Action else set the InProgress column value in SP to true and follow the flow.

 

Understand?

 

Best Regards,

 

Gustavo Moraes


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Understood, I'll give it a shot

 

thanks!

 

Pandra
Level: Powered On

Re: Listen for updates to SharePoint List

Gustavo, all works as expected. Thanks again for the help!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 283 members 2,970 guests
Please welcome our newest community members: