Answered

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

Like (0) Share

Report

Posted on 4 Mar 2023 14:20:23 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:

Dataflows

All responses (3)

Answers (1)

Verified answer

ChrisPiasecki 6,397 Most Valuable Professional on 04 Mar 2023 at 19:19:32

Like (0)

Report

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

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.
bdherh1 74 on 04 Mar 2023 at 19:12:06

Like (0)

Report

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

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
ChrisPiasecki 6,397 Most Valuable Professional on 04 Mar 2023 at 14:53:19

Like (0)

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

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.