Help. Filter userid/ text from one of the column and send mail.

[iwsejet]

Hi,

I am new to Power Automate, I have a list in which one of the columns has notes/text I am interested in the user id. I need to filter out/Identify the User id and send mail to the user automatically.

Sample List:

In the above sample Userid: SS913D / S@gmail.com.

Please share your thoughts.

Thanks.

[FLMike]

Hello,

Is the format of the text the same? So that in the stored text, it seems like there are multiple lines of text and somewhere in there is the user id and email correct?

• If the format of the username and email are the same no matter where they exist in the text, do you have a format relative to userids. I do see your example SS913D, but what would the valid ranges/formats of the user id's be?
• Is it accurate that you need to search through the entirety of the notes/text to find it, versus its always the N characters, or last characters etc?
• And is the format SS913D / SomeEmailAddress literally what the format is with the / and all?

Since we need to figure out the best way to search(parse), then we need to come up with a valide reusable pattern.

Cheers,

Cheers
--------------------------------------------------------------------------------
If I had answered your question, please mark your post as Solved
If you like my post please give it a thumbs up
Thanks
Michael
https://gernaeysoftware.com

[Nived_Nambiar]

Hi @iwsejet 

Just to confirm, does the userid exists in the formt SS913D or in this format SS913D/S@gmail.com ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

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

[iwsejet]

Yes, I need to search the entire stored text and somewhere there is Userid keyword and next to it will be the actual userid(SS913D) which I need to fetch.

The format will always be Uppercase alphabets and numbers mixed up and no special characters. (Ignore the format S@gmail.com.)

Sample text:

39 records in t.com
     39 times user_id IN34 has Accessed the table AC

t.com
273 records in t.com
    273 times user_id IN45 has Accessed the table AC
t.com
5255271 records in t.com
5255271 times user_id INH34 has Accessed the table AC

[iwsejet]

userid exists in the format SS913D, mix of uppercase alphabets and numbers no special characters.

39 records in t.com
     39 times user_id IN34 has Accessed the table AC

t.com
273 records in t.com
    273 times user_id IN45 has Accessed the table AC
t.com
5255271 records in t.com
5255271 times user_id INH34 has Accessed the table AC

6 records in P
6 times user_id SS913D has Accessed the table PO

[FLMike]

Morning,

Thanks for the update. I do have one last quick question. I notice it seems to always say has Accessed the table XX. Is that also accurate that it will always say that or will it possibly say something else?

Right now I already have an idea in how you would do it, but if it says  user_id XXX has, it will make it even easier

[iwsejet]

Morning,

It will always say "has accessed table", but the name and length of the table varies. 

user_id is the keyword and following that will be the actual userid of interest (SS913D,INH34,..)

[FLMike · Accepted solution]

Hello,

Add a Compose action in (for each row) that does this to that column. The output will be the user id

Trim(Split(Trim(split(variables('SplitValue'),'times')[1]),' ')[1])

Just remember to change where I have variables('SplitValue') to whatever variable or output you have that has the actual text from the column.

I did this on the string "39 times user_id IN34 has Accessed" and the answer is IN34

and on "6 times user_id SS913D has Accessed the table PO" and the answer is SS913D

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[iwsejet · Accepted solution]

Makes sense Mike. That did work as expected.

Thank you.

As a next step I created a column and saved the user and created Rule in Sharepoint to send Automated mail to the user.

Quick Question: Is there an option to create a form as the next step and get some info from the user (previous step) and save the info from Form in different column in Spreadsheet.?

[iwsejet]

Hi,

Below is my overall flow.

1.When a new mail is received. 2. File is copied and stored in Documents. 3. Content of the file is passed to Compose to extract the User_id. 4. New item is created in share path.( If there are multiple user_id in the Body create multiple rows in Share path .5. Send mail to user_id.

I have used the initialized variable and compose as you suggested, and I am able to extract User_id as expected.

But the issue is when I am sending multiple rows/references to user_id only one is getting executed (1 row created in sharepoint with mail being sent to user_id) and the next is not pulling up.(nor new item created).

In the below case, first ls1097 user_id is pulling up and not the second.

Can you share your thoughts.

Thanks.

[FLMike]

Hi 

if you can please make the original as resolve I’m happy to help out. Reading the rest now. 

[FLMike]

Hi

a suggestion. I make this to everyone. If you can rename the actions what they do it will help follow the code. 

unfortunately all of your actions are closed so I can’t see what your doing to answer you. 

also note that you should not use variables in Apply to Each loops unless you change the concurrency to 1 because it will definitely break stuff. 

always pass data based on the output of the Apply to Each or do a compose in the loop without variables. 

once you open all your actions and make sure I can see the names so I know what they are doing I’ll respond back to help. On my phone atm so even harder to see hehe. 

thanks