How to send emails to certain users based on ID

[MohamedGrt]

Hi everyone,

So I am looking into how to send certain values to specific emails based on ID. for instance: I want to send (VALUE 1 & VALUE 2) when a person sends me an email indicating his/her ID, and send back the values to the allocated email, I believe it could be done using Power Automate, but I am not sure about the right workflows used, any support will be appreciated.

[fchopo]

Hi @MohamedGrt 

We would need a more clear explanation:

a) "I want to send (VALUE 1 & VALUE 2) when a person sends me an email indicating his/her ID": Where is this ID indicated? In the body of the email? In the subject?

Regards,

Ferran

[MohamedGrt]

Hi @fchopo 

lets say in the Subject as it seems more convenient for the sender and the system to understand i would assume.

Thank you in advance

Mohamed

[fchopo · Accepted solution]

Hi @MohamedGrt 

You could do the following:

1) When a new mail arrives with a Subject like "User ID: 2"

2) Get the User ID from Subject, using the expression:

replace(triggerOutputs()?['body/subject'],'User ID:','')

3) Show the excel rows filtering by ID

4) For each row (there's only one), send an email with value 1 and value 2

Hope that helps!

Ferran

[MohamedGrt]

Thank you @fchopo 

In the Compose step, I could not find the "Replace" expression and therefore I had to copy and paste it.

However, the error I encountered did not target that step but the "list rows" one,

I can't see the statement written in Filter Query and I think the error resides there.

[MohamedGrt]

Here is a snapshot of the error

[MohamedGrt]

Hello again @fchopo 

Thanks a bunch for the support. it worked!!!

Best,

Mohamed