Help with power automate flow failing to 'Add a new row' using invoice processing ai

(0) Share

Report

Posted on by CU18062040-0

I'm hoping someone can help me with a Power Automate flow that's giving me a persistent error.

I'm trying to build an AI flow where a user uploads quotations to a "Requisition" record, and the flow automatically analyzes them and populates a "Quotation Comparison" subgrid on the form.

Initial Attempt (Notes/Timeline): I first tried triggering the flow when a file was added to the Notes (timeline). This seemed unreliable and often didn't trigger correctly for me.
Current Attempt (Dedicated File Columns): I've now switched to what I think is a better design. I have three File columns (Quotation 1, Quotation 2, etc.) directly on my Requisition form. My flow triggers "When a row is modified" and is set to only watch these specific file columns.

My flow is failing on the final "Add a new row" step with an ODataUnrecognizedPathException when I try to set the lookup field back to the parent Requisition. It seems I'm not referencing the parent record correctly from the trigger.

Has anyone run into this OData error when setting a lookup field in a flow that's triggered by a modification on the parent record itself? What is the correct way to format the lookup value?

I've attached screenshots showing my flow setup and the exact error message. Anyone know ways I can make this flow work

Thanks in advance for any advice!

Categories:

Building flows

Screenshot (92).png

Screenshot (94).png

Screenshot (95).png

I have the same question (0)

All responses (2)

Answers (0)

DexPoint 185 on at

Like (0)

Report

when you are in the flow, can you click the raw inputs and raw outputs.

it says the resource could not be found, is it finding an actual field or showing up blank?

I havent worked with any of the components you are using but id recommend throwing a compose action in there if you are unsure and make sure that the URL has data. throw it into the compose action to verify and then confirm something is there.

Then maybe use the Compose output into the Add a Row action.

Was this reply helpful? Yes No
Suggested answer

Building with Why 351 Super User 2025 Season 2 on at

Like (0)

Report

The correct format is to use the set name of the name followed by ({record})

as an example contacts({GUID})

You can get the set name by clicking the Tools for the table.

If this helped, please mark this as Liked and Verified.

Was this reply helpful? Yes No