Power Automate

[Abi-Ola]

Hi, I am to create a logic to send an SMS whenever a task is created that meets a particular criteria.

- I started my logic as when a Row is Added
- Table Name: Task
- Subject Contains (Bla Bla)
- Apply to EACH (Create a new record)
- Table Name - Phone Message (an existing table )
See attached

I want to use the 'mobile' number in the contact entity regarding each task.

How can I better achieve this, please?

[Mira_Ghaly]

@Abi-Ola 

The flow looks good but I do not get what is the need for the Apply to each? Is it to get the contact?

[Abi-Ola]

Hi Mira, You are right; ' apply to each' is pointless since it applies to individual records. Just curious, though, if I have 200 tasks added at a go, I hope they will all be treated individually?

Any idea on how I can get the regarding contact and make sure the column is added to the number column in my add a new record

[Mira_Ghaly · Accepted solution]

@Abi-Ola 

Yes they will be treated individually.

For the contact you need to get the contact using Get Row By Id and pass the regarding (Value) from the trigger as below