cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Help with List Modified rule

Hi,

 

I'm testing a Flow from a SharePoint list.

I'm wanting an email to the admin and to the user when a list item has been created, when modified.

I'd like another email that states it's been modified. I'm getting myself a little confused. 

 

I've got 'When an item is created or modified' > Get my profile (V2) > 1) Send an email (V2) = admin 2) Send an email (V2) = user

These emails a work fine.

For the flow to send an email when the list is modified. After 'Send an email' do I add a 'condition' to state that when the column in my list has been changed, then send an email?

 

Any ideas / opinions are appreciated

.flow.JPG

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Help with List Modified rule

Hi @David_LN_,

 

Could you please share more details about your issues?

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Highlighted
Frequent Visitor

Re: Help with List Modified rule

My issue is, I'd like an explaination to how I can get a modified SharePoint list to email a user.

Highlighted
Community Support
Community Support

Re: Help with List Modified rule

Hi @David_LN_,

 

If you want to send the item in email, you could refer to screeenshot below to create the flow:

Capture.PNG

Capture.PNG

 

 

Best regards,

Alice

Highlighted
Frequent Visitor

Re: Help with List Modified rule

Hi @v-yuazh-msft

Thanks for the screen shot!

I've copied the details. However, my Flow received an error on 'Get Items'

2_chrome_2018-12-04_10-43-57.png

 

Body: 

{

"status": 400,
"message": "Column 'Identifier' does not exist. It may have been deleted by another user.\r\nclientRequestId: 041ed1ff-4d1e-4b44-a112-f74b8781887e\r\nserviceRequestId: c5afa89e-808c-7000-5ea7-059d366440c1"
}
What am I meant to be putting in the Filter Query column? 
Thanks,
Highlighted
Community Support
Community Support

Re: Help with List Modified rule

Hi @David_LN_,

 

Sorry for it don't works.

 

I have made a test on my side and find that you could use the ID to filter the item instead of Identifier, and the screenshot of the flow as below:

Capture.PNG 

 

Please take a try on your side and let me know if your problem could be solved.

 

Best regards,

Alice

Highlighted
Frequent Visitor

Re: Help with List Modified rule

Hi @v-yuazh-msft

I changed the flow settings to 'ID' which worked! No errors.

A different issue. After I've created 'Create HTML table' then add 'Send an email 3' you have 'Output' in the Body.

My flow doesnt allow me to save without adding to the 'To' or 'Subject' fields.

When doing so, it adds 'Apply to each'.

But your's hasn't done that from the image? 

helpdesk1.JPGhelpdesk2.JPG

Highlighted
Community Support
Community Support

Re: Help with List Modified rule

Hi @David_LN_,

 

The "Created by Email " Dynamic of "Get items" action is an Array, if you enter the "Created by Email " Dynamic of "Get items" action in the "To" field of "Send an email" action, the flow would add an "Apply to each" automatically, and send the email to the creator or each item.

 

If you want to send the email to only one person, please just enter the email address of the person in the "To" field of "Send an email" action.

 

Best regards,

Alice

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (4,940)