cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djoeg01
Kudo Collector
Kudo Collector

Trouble with " To" email address from sql field (no Receipiant)

Hi,

Im getting errors with recipient invalid when adding the "To"  email address from a sql field. 

 

It appears the To address is Blank. (see screenshots)   I trigger the flow when a new record is created then use sql Stored procedure to update the email address. Ive added a delay (45 sec)  to ensure the SP is complete before sending the email.

 

not quite sure why this is happening, except that maybe the email is running too soon ?

 

any help is apprciated.

thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @djoeg01 ,

 

As @yashag2255  asked, please share the run screenshot of the execute stored procedure actions in the run history and check if the email address is exist.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4

Hi @djoeg01 

 

Can you please add the screenshots again? For some reason those didn't come in and I am unable to look at it. This will help us better identify the issue and assist you with this. 

 

I am guessing you have certain more actions related to sharepoint and you have added a delay to reference to the output of these. You can probably check the output from tehse actions if the expected values are being returned in the appropriate attributes. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

My Bad, forgot to attach screenshots. 

 

Im not using Sharepoint only SQL and the Stored Procedures (SP) to update the new record to add the email address, I put in a delay to ensure the SP had completed before the email portion gets kicked off.

 

flow2.JPGflow1.JPGflow3.JPG

Hi @djoeg01 

 

Can you expand the execute stored procedure actions in the run history and check what output you are getting? (are you getting the expected data there?)

v-alzhan-msft
Community Support
Community Support

Hi @djoeg01 ,

 

As @yashag2255  asked, please share the run screenshot of the execute stored procedure actions in the run history and check if the email address is exist.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,036)