Unanswered

Creating a new row in dataverse from a Microsoft Form response

(1) Share

Report

Posted on by JamesJenkins

I'm having an issue with creating a new row within accounts and contacts within dataverse using a Microsoft Form.

Creating the actual rows for both 'Accounts' and 'Contacts' wasn't an issue, and I have done that successfully. However, both entities are related to eachother and I need to show this in the rows.

I get the following error when trying to link the contact to the account: Action 'Add_new_row_(Contacts)' failed: URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL.

If anyone is able to assist that would be great!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @James05

To add value in lookup column of Dataverse table, pls follow the steps as mentioned in one of my previous solutions:

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
JamesJenkins 21 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,

Thank you for your response, I have followed the solution in your previous post and unfortunately I am still having issues with my flow.

I am not able to edit the code as it says 'Cannot edit in read-only editor', I have used the unique identifier to link the child account to the parent account in the 'Parent record reference' column.

Please could you assist me further?

thank you!

James

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi James,

Pls share screenshot(s) of the flow in edit mode.

Was this reply helpful? Yes No
JamesJenkins 21 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,

Please see screenshot, let me know if you need more detail (I am new to this):

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi James,

You need to pass the unique identifier of newly created account record from the dynamic content window.

Here is an example:

accounts(<dynamic unique identifier>)

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
JamesJenkins 21 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,

Thanks for your help, this is now showing within the contact that they are related to the account.

However, I now would like the account to show that the Primary Contact is the contact row that has just be created.

I assume this would be achieved the same way 'contacts(uniqueid)' under the 'Primary Contact' field in the 'add a new row' for accounts.

However, the add a new row for accounts happens before the contact, therefore the unique id is not showing as an option under 'Primary Contact'. Please see below image for reference:
I used 'get a row by ID' and inserted the unique id with 'contacts(uniqueid)' in the primary contact field. however it didnt link the even though the test ran successfully. For reference, I am gathering the data and presenting it using Power Apps (process driven) in the image below:

If you need anything else, please let me know.

Thanks for your help so far its been really helpful.

James

Was this reply helpful? Yes No