Unanswered

Populating a dataverse lookup column

(1) Share

Report

Posted on by Ben_C

I am trying to build a flow which creates a row item, one column references a custom table called Audit Records. The relationship is Audit ID. Though I'm getting the following error "Resource not found for the segment 'devpub_auditrecords'."

Here is the lookup column, I also have a look up to the account tables, which is writen out in exactly the same way and that works fine.

Any advice would be most appreciated.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

eric-cheng 5,171 on at

Like (1)

Report

Re: Populating a dataverse lookup column

Hi @Ben_C ,

You are right in that it is

/pluralisedtablename(guid)

Can you please put the Audit Records value into a Compose action and see if it is in fact a single GUID for the Audit Record?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Ben_C on at

Like (0)

Report

Re: Populating a dataverse lookup column

Hi, thanks for the reply, here is the output from this table item.

Audit Records = 559e2b9e-49ab-45ce-b48a-382e5b643e67

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Re: Populating a dataverse lookup column

Hi @Ben_C ,

Can you add a Get Row and specify the Audit Records table and paste the same GUID as row id and see if it returns the intended record?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Re: Populating a dataverse lookup column

Hi @Ben_C ,

In addition to the above, can you also go to Data > Tables, click on the Audit Records table, click on Settings and check the plural display name? Example below for accounts.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Ben_C on at

Like (0)

Report

Re: Populating a dataverse lookup column

I have a get row at the start to pull through the table row ID, I chucked in a compose to check it was pulling through the right record and I can confirm it is.

Was this reply helpful? Yes No
Verified answer

Ben_C on at

Like (3)

Report

Re: Populating a dataverse lookup column

I double checked the plural name and its actually Audit Records however I still get the same error.

As it has a space in the name do I need to put it between two '?

---EDIT---

I required adding an es to the end of the pluralised name, so althought the pluralised name was displayed as audit_records, it only works if you use the following:

audit_recordses
For example: 'Audit Records'

Was this reply helpful? Yes No
lachlanP 107 on at

Like (0)

Report

Re: Populating a dataverse lookup column

Could someone in this thread help me with the basic Accounts table example?

What is meant to be passed to the function? The Account ID GUID or the Primary Name column? I cant seem to get either to work.

Here is what I'm trying: I have a compose with the account ID (for testing)
Then I am passing it to Dataverse via the Update a Row function like this:

And I'm getting the error:
"Resource not found for the segment 'Accounts'."

Was this reply helpful? Yes No
PowerInk 23 on at

Like (3)

Report

Re: Populating a dataverse lookup column

@Ben_C wrote:
I double checked the plural name and its actually Audit Records however I still get the same error.

As it has a space in the name do I need to put it between two '?

---EDIT---

I required adding an es to the end of the pluralised name, so althought the pluralised name was displayed as audit_records, it only works if you use the following:

audit_recordses
For example: 'Audit Records'
Ah, I see. You have to channel your inner Gollum.

Was this reply helpful? Yes No