Unanswered

How do I automate Microsoft Lists to update based on Emails sent

(0) Share

Report

Posted on by EmMoratti

Hello!

I am trying to use Microsoft Lists as a contact management system. I want to create a flow that does one of the following:

1) Every time I send an email to specific contacts, I would like it to update the list to reflect the date of last contact

2) Manually trigger a flow to search my email and update the list with the date of last contact for each contact emailed

Thank you!

@v-Jefferni helped me last time but the link to the answer is broken :,(

Categories:

Building flows

PowerAutomateAnsw...

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

The easiest way to achieve this would be to add a button flow in your Microsoft listing. You can click it trigger and email and update the current item.

You could either simply use the context menu to run the flow or use JSON formatting for a better user experience.

Run Flows Directly from SharePoint List/Library Using JSON Column Formatting

Was this reply helpful? Yes No
EmMoratti 14 on at

Like (0)

Report

Would I have to add a button flow to every single contact? Or could I just have one button that scans my email for every entry in a given list?

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

You need to just add a column to your Contact list that will be formatted to appear like a button.

When clicked, this button will trigger a Power Automate flow to notify the selected contact and record that a notification has been sent.

Was this reply helpful? Yes No
EmMoratti 14 on at

Like (0)

Report

Would you be willing/able to write out the instructions for me or attach some screenshots? I'm very new to Power Automate and I bit off a little more than I can chew!

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Ok send me a screenshot of your Contacts list

Was this reply helpful? Yes No
EmMoratti 14 on at

Like (0)

Report

Thank you!!

See attached screenshot; I had to redact sensitive data so let me know if you have any questions.

Essentially I would like it to be able to scan my email sent folder, and update the DAte Last Contacted (and last activity if possible) to have the date that I last reached out to any email in the list

Was this reply helpful? Yes No