Answered

On Add new row, what to put in the primary key if it is Autonumber?

(0) Share

Report

Posted on by bdherh1

I have a flow that is creating a new row based on other table rows. Once I get to the Add New Row, it is prompting me with an required field the primary key of the table I'm adding it to. It is defined as a prefixed autonumber. Not sure what need to put. See below

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @bdherh1,

You can either:

Make the column optional in the column settings within the table designer in maker portal.

Populate the value with the expression Null in your flow. The platform will take care of populating the correct Autonumer value.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
bdherh1 74 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I figured since it was the primary name column. It defaulted to Required and I left it. I just changed it to Optional and it took. I will try it on my form in a bit

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

On your forms you should make the Autonumber field read only.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No