Answered

Power automate Flow Failed

(0) Share

Report

Posted on by MG-08080656-0

Hello All

I'm a Power Automate developer working on a flow to trigger emails in Power BI. I'm facing a strange issue—my flow status shows "Failed," yet I'm still receiving emails. The error message states: "To cannot be null or empty." However, the "To" field is populated with email IDs from the Power BI dataset, and I've confirmed that there are no null values in the dataset or the "To" field itself.

I'm struggling to understand the root cause of this issue. Could this be a Power Automate glitch, or is there another factor at play? Any insights or suggestions would be greatly appreciated.

Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Ellis Karim 12,008 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

From the runtime output, can you expand the Send an Email from a Shared Mailbox action and check what value is in the To: field.

Or add a compose action before the Send an Email from a Shared Mailbox. The compose action should contain the actual email address value used in the end an Email from a Shared Mailbox action. Then re-run the flow, if this is an option.

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
MG-08080656-0 38 on at

Like (0)

Report
Copy link

Link copied!

It does not have any "To" Section in the failed flow..pretty wierd..same flow run. with 1 email ID passed.. failed one ran with 6 email Ids...(example) and yet all 6 of them got the emails
Below are sceenshot

Was this reply helpful? Yes No
Ellis Karim 12,008 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

When the To: field in the "Send an email from a shared mailbox (V2)" is null or empty, the To: field will be missing from the runtime output.

So, this does indicate the you have null or empty email values in your data set.

You can confirm this by adding a compose action containing the email property as shown below. Add the compose action before the "Send an email from a shared mailbox (V2)" action, and then examine the runtime output.

When viewing the runtime, make sure you cycle through all the failed items in the loop:

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
MG-08080656-0 38 on at

Like (0)

Report
Copy link

Link copied!

Issue resolved. thank you

Was this reply helpful? Yes No