Answered

added for a dataverse table a column with type autonumber but canvas app cannot add new rows

(0) Share

Report

Posted on by candide

hi,

I created a canvas app and there is a tblKapitel with column ID, but it's type is whole number.
I needed to change the ID to Autonumber which is not possible in a straight way.
The only way I found was to export the table as excel file, add to tblKapitel the new column ID2 as autonumber and then import the excel file again.
Import was ok and ID2 values where filled.

I adapted the canvas form (added ID2, deleted the datacard ID) but when trying the canvas app does not allow me to add new rows.
Editing existing rows is possible. And yes, I published the tblKapitel after the change.
And also tried with another browser (chromium) but adding a row still fails with this error message:

cannot be saved. Check whether there are any errors in the form

Whats going on here?🙄

thx

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Mahendar Pal 191 on at

Like (0)

Report

Hi,

Please recheck your expression, there should be something else which is causing issue , I tested it will a dummy student table which has Roll No as a autonumber and it's working fine as you can see I am setting only two field.
Patch(Students,Defaults(Students),{'Primary Name':DataCardValue3.Text,Name:DataCardValue1.Text})

It's working fine.

Was this reply helpful? Yes No
candide on at

Like (0)

Report
All I saw in the form was the Save button with error:
the new_ID field is required
which led me to the error.

It was tricky to find out but I had an old column ID (the new is named ID2) and column ID was still set required. I changed it to optional and now I can save a record.

That's fine.

BUT...
as stated above I exported the table to Excel, added column ID2 and imported in Dataverse.
But the new added table row starts with 1 and NOT with something like Max(ID2)+1 as expected.😖
Seems I will try the export/import again and see?

Was this reply helpful? Yes No
Verified answer

candide on at

Like (0)

Report

the way that was my solution:
export the table. You will see that the column ID2 which is Autonumber will not be exported. Then I deleted ALL the rows in the table.
The seed of ID2 should start with 1 and has 4 digits so it starts with 0001.

Then the import from Excel was executed. In my example it starts with 0002 instead the expected 0001 - whatever the reason is - its not so important as it's an artificial key column. More important it never has duplicates and entering a new row via canvas form the ID2 is correct [like Max(ID2) plus 1]
😀😁
thx to all

Was this reply helpful? Yes No