Unanswered

SharePoint- Create automate to check for user then copy

(0) Share

Report

Posted on by RobertVT

I have a list where I am capturing users when they need to be sent an email after they have been added to the list. Once they have been added once, if they need to be sent another email the next week because they didn't do an action from the initial entry, I want to check the list and if the user already has an entry in the list, I want to count how many times they showed up and since each entry is an issue, I want to copy each time they showed up to a new list with how many times they showed up. So I can track a report how many times they showed up. So we can tell how many users aren't addressing the issue we're reporting on. Hope that makes sense. Just filtering the count in the view won't work. I need to see all in the list with each instance they showed up in the list. For reporting. Any ideas?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RobertVT

From power automate- you need to create flow which sends an email to user for each entry in list when created correct ?

Also i couldn't link this reporting concept and how that to be done in Power automate- could you elaborate please ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RobertVT 34 on at

Like (0)

Report
Copy link

Link copied!

No, I already have an automate that sends the email. The issue is I get a report that shows weak settings. Based on the username I send that user an email weekly if they still show up on the report. They will show up weekly if they don't change this setting. What I am trying to attempt to do is when I load a new batch if the name already shows up in the list. I want to capture how many times they showed up and copy their entries to another list and show that count how many times they show up or duplicated into another list. This would be a growing number. The problem is finding the name in one list, checking how many times they show up and then adding a count number next to their name so I can see who is not adhering the request to change their settings. Basically, wanting to track who the worst offenders are based on how many times they show up in the list.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RobertVT

Got your flow design now.

So you want to design a flow which should trigger on creating list item in SP List> it should send an email regarding this to user , also once email is send, you have to make the flow to move the item to next list , so next time when user creates same username which already created before- it should check how many such users are already created by comparing previous list and taking a count and sending email with count - correct ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RobertVT 34 on at

Like (0)

Report
Copy link

Link copied!

Close. You have most correct. Except at the end I'm not needing to send another email. From the first list, I'm wanting a flow that checks the list of users with issues and copies their username into another list AND then looks at the initial list and counts how many times they show up in the initial list and keeps a count next to their username in the new list with a count of how many times they showed up in the initial list. I'm trying to automate the count so I can keep track of which users didn't make updates after multiple emails sent based on the email sent from the first list. Hope that makes sense. I know I could manually just run a count filter but that's manual. Would take forever. I need the count to be in a column so I can see at first glance biggest violators. Does that make sense?

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RobertVT

Fine on SP List part- but on mail part still confused- how to send the email? does the count of how many times alert emails has sent to person/user should be included in the email body while sending ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RobertVT 34 on at

Like (0)

Report
Copy link

Link copied!

The email is sent by an automate I've already created. There's no assistance I need in the email. I'm trying to figure out a way Everytime they show in the list, correlate the user if there in the count list if not add a line item in the count list for that user. As I continue to add the next report and if the user shows up again, then check the count list. If not there create the line item. If already there check the count column and add another value for each time the user shows up in the initial report list.

Was this reply helpful? Yes No