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

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
Community Support Team
Community Support Team

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

David_LN_
Level: Powered On

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.

Community Support Team
Community Support Team

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

David_LN_
Level: Powered On

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,
Community Support Team
Community Support Team

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
David_LN_
Level: Powered On

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

Community Support Team
Community Support Team

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,605)