Creating a new row in dataverse from a Microsoft Form response

[James05]

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!

[ManishSolanki]

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.

[James05]

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

[ManishSolanki]

Hi James,

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

[James05]

Hi Manish,

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

[ManishSolanki]

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.

[James05]

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