Populating a dataverse lookup column

[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. 

[eric-cheng]

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

[Ben_C]

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

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

[eric-cheng]

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

[eric-cheng]

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

[Ben_C]

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. 

[Ben_C · Accepted solution]

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'

[lachlanP]

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'."

[PowerInk]

---

@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.