Populating Lookup Fields from another table

(0) Share

Report

Posted on by JohnM86

590

Hi everyone,

I'm in a bit of a pickle and would appreciate some guidance to resolve this. I have read numerous threads but none of the suggestions appears to be working for me. To summarise:

I am working on a flow to auto-create a project from a quote process - the flow runs fine till it gets to the add a new row where it keeps failing with the error URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL. As previously explained, I have read numerous threads which dictate to use the plural name etc.. all of whihc i have attempted.

i.e Project Categories, projectcategories, projectcategorieses, Project Categorieses and so on however, none of these appear to be working.

i will attach images below:

As you can see - it is finding the category guid fine and pulling it through

The make-up of the flow is :

The flow keeps failing here at project categories and no other fields are completed as of yet as. Please point me in the right direction 🙂

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Ok so I have figured this part out - rather than use the 'Project Categories' as displayed I had to use 'Categories' - rookie error

I'm now stuck with this error when trying to pull account data over The supplied reference link -- accounts() -- is invalid. Expecting a reference link of the form /entityset(key).

it appears to keep pulling a null value - similar when using compose

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

#

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Accounts field sorted - now its a similar issue with Contractors (Contractor Accounts) URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL.

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Figured this issue out - it appears that with any account type, you need to use accounts i.e. accounts(contractoraccount) etc 🙂

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

ok so i have 95% of the fields working correctly - the only issues im having now are with fields

Linked Quote (Quotes) - field to link a quote to a project
Linked Project (Projects) - field to link project to quote
And the population of yes/no fields - I used a custom value and inputted the value of the selection from the quote form to transfer to the project form but the values do not transfer.

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

oh how weird - so i figured this out - it seems to be categories i.e categories(quoterequestlink) etc.. same with project link

So if any one is struggling with this in future the only three things i could get to work were - systemusers, categories & accounts but all is working fine 🙂

Just to figure out the yes/no values now 🙂

Was this reply helpful? Yes No