cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
David_LN_
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
v-yuazh-msft
Community Support
Community Support

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

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

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

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,

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

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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (43,617)