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

(0) Share

Report

Posted on by djoeg01

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.

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
djoeg01 38 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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?)
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.