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!

All responses (6)

Answers (0)

JamesJenkins 19 on at

Like (0)

Report

Re: Creating a new row in dataverse from a Microsoft Form response

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
ManishSolanki 14,981 on at

Like (1)

Report
Re: Creating a new row in dataverse from a Microsoft Form response

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.
JamesJenkins 19 on at

Like (0)

Report

Re: Creating a new row in dataverse from a Microsoft Form response

Hi Manish,

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

Like (0)

Report

Re: Creating a new row in dataverse from a Microsoft Form response

Hi James,

Pls share screenshot(s) of the flow in edit mode.
JamesJenkins 19 on at

Like (0)

Report

Re: Creating a new row in dataverse from a Microsoft Form response

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 14,981 on at

Like (1)

Report

Re: Creating a new row in dataverse from a Microsoft Form response

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.