When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Like (0) Share

Report

Posted on 1 May 2024 15:41:03 by KN-28051416-0

A referral can have multiple intakes. In the flow below ("add a new row" stage), how do i add the referral id (primary key in referral table) in the lookup field (Referral Lookup) of the intake table. Other columns including referral table columns, other lookups (clientid from client table) work by using plural_logical_name(col_name) but the referral id does not work!
P.S: I did try creating a non-lookup column in the intake table and assigned the referral_id from the referral table to it and that works.
Thanks.

Referral table logical name: cr7de_hf_referral

Categories:

Business Process Flows

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (6)

Answers (1)

KN-28051416-0 26 on 01 May 2024 at 18:57:35

Like (0)

Report

Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Awesome. It worked. Thanks!
I made a mistake by creating a lookup to referralid and not to the guid. I created that relationship and tried what you suggested at the end and it worked.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on 01 May 2024 at 16:28:59

Like (0)

Report
Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Hi @keerthana_n

From dynamic content, you need to pass unique identifier (guid) of the record which looks similar to table display name.

In your case, you will see guid value as 'Referral' in dynamic content window. Pass that property instead of 'Referral Id'.

cr7de_hf_referrals(<dynamic unique row identifier from trigger which looks same as table name>)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
KN-28051416-0 26 on 01 May 2024 at 16:20:43

Like (0)

Report

Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

I tried that. It gives me this error: Bad Request - Error in query syntax.

It worked for other lookup columns and Program column gets the value from the referral table.
I'm wondering if it is because referralid lookup is the primary column of referral table where as program is a lookup in the referral table.

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 01 May 2024 at 16:17:07

Like (0)

Report
Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Hi @keerthana_n

Pls try this for lookup column:

cr7de_hf_referrals(<dynamic unique row identifier from trigger>)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
KN-28051416-0 26 on 01 May 2024 at 16:12:16

Like (0)

Report

Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Thanks for your reply. My intake table does create a record but only the lookup column from the previous step(Referral table) does not get updated.

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 01 May 2024 at 16:08:38

Like (0)

Report

Re: When a record is added in a table (referral), a record needs to be created in another table (intake). Referral id lookup column in the intake table throws this error : "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Hi @keerthana_n

Pls refer my solution in another post for the same issue:

Flow won't create row in Dataverse, and no error r... - Power Platform Community (microsoft.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No