Power Up Program - Power Up Final Challenge

Flow run failed error

Like (1) Share

Report

Posted on 15 Mar 2025 18:45:28 by CU06021230-0

The Foster Claimer Name finally shows up in the email. Now i'm getting a flow run failed error. I've played around with it & it's a different error for each one.
Get a Row by ID> Foster Family Informations Table > Foster Claimer then Get a Row by ID >Foster Claimer Name
Get a Row by ID> Foster Family Informations Table > Foster Claimer then List Row > Foster Claimer Name

Categories:

General Discussion

All responses (13)

Answers (0)

w.p 678 on 16 Mar 2025 at 17:00:48

Like (0)

Report

Flow run failed error

It doesn’t take a week.

You don’t need "Get a row by ID 2" and "Get a row by ID 3"
You should be able show "Foster Claimer Name" from your previous "Get a row by ID" action.

I suggest creating a new flow in Power Automate from scratch and try retrieving the "Foster Claimer Name" first before adding conditions.

Join the weekly live session for a detailed walkthrough.

If you want to continue with this flow, can you show the output from "Get a row by ID"

An example of my output:
CU06021230-0 32 on 16 Mar 2025 at 11:18:25

Like (0)

Report

Flow run failed error

No it took a week to get Foster Claimer Name to show up as an option https://community.powerplatform.com/forums/thread/details/?threadid=b9d78baf-dbfc-ef11-bae3-6045bdf03fcb

The only way I was able to get it to work was to do get a row by ID twice.
Suggested answer

w.p 678 on 15 Mar 2025 at 20:42:17

Like (0)

Report

Flow run failed error

Now I know what the problem is

1-This icon indicates an error in this action

2-Error description

3-❌ Row ID = Foster Claimer Name (need foster claimer ID, not name)

Remove this action "Get a row by ID 3"

You can get or show "Foster Claimer Name" from your previous action "Get a row by ID"
CU06021230-0 32 on 15 Mar 2025 at 20:29:11

Like (0)

Report

Flow run failed error
w.p 678 on 15 Mar 2025 at 20:09:56

Like (0)

Report

Flow run failed error

I see you used a nested condition, I'd like to see more on this error part.
CU06021230-0 32 on 15 Mar 2025 at 19:50:58

Like (0)

Report

Flow run failed error
w.p 678 on 15 Mar 2025 at 19:12:53

Like (0)

Report

Flow run failed error

This part shows the error, but I can't see it. Can you share the full screenshot?

EDIT: It seems you added more 'Get a row by ID' actions in this part.
CU06021230-0 32 on 15 Mar 2025 at 19:05:08

Like (0)

Report

Flow run failed error

Posting the code into the reply isn't working so here is a screenshot
w.p 678 on 15 Mar 2025 at 19:04:32

Like (0)

Report

Flow run failed error

For the "Get row by ID" error, couldn't see the actions in Yes/No part.
w.p 678 on 15 Mar 2025 at 19:02:53

Like (0)

Report

Flow run failed error

remove the "List rows" action