Answered

Autoincrement in Powerapp with an excel file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,
I am developping a form via powerapps and the request are recorded in a excel file.
But I got a situation with the autoincrement.

I create a label in which I have an ID with the following formula :

First(Sort(Table_owssvr;ID; Descending)).ID+1

The ID is well displayed but doesn't update on the excel file.
Here's the formula in the update field for the data card : Label2_3.Text

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You might consider using the value of that in your Update property:

Value(Label2_3.Text)

Also, if your ID is numeric, you can also consider altering your label formula to the following:

Max(Table_owssvr; ID) + 1

It's a little better performance and clearer to read.

I hope this is helpful for you.

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Do you format your Excel as Table and then store it in one plateform for example One Drive?

What is the data type in your excel Table?

There is no wrong with your formula expression and it test OK on my side.

Data Source: Excel Table in my OnDrive,ID(general)

Label2.Text=First(Sort(Table1_1,ID,Descending)).ID+1

ID_DataCard1.Update=Label2.Text (ID:General)

ID_DataCard1.Update=Value(Label2.Text) (ID:Number)

You can also consider to use patch,

Patch(Table1_1,Defaults(Table1_1),{ID:Label2.Text}) (ID:General)

Patch(Table1_1,Defaults(Table1_1),{ID:Value(Label2.Text)}) (ID:Number)

Best Regards.

Yumia

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I still have the same issue.
I get no ID in the excel file which host in a onedrive.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I still have the same issue.
I get no ID in the excel file which host in a onedrive.
And the patch doesn't work.
It gets back the error message : "You can't use this property to modify elsewhere in the application"
@v-yuxima-msft wrote:
Hi @Anonymous

Do you format your Excel as Table and then store it in one plateform for example One Drive?
What is the data type in your excel Table?
There is no wrong with your formula expression and it test OK on my side.

Data Source: Excel Table in my OnDrive,ID(general)
Label2.Text=First(Sort(Table1_1,ID,Descending)).ID+1
ID_DataCard1.Update=Label2.Text (ID:General)
ID_DataCard1.Update=Value(Label2.Text) (ID:Number)

You can also consider to use patch,
Patch(Table1_1,Defaults(Table1_1),{ID:Label2.Text}) (ID:General)
Patch(Table1_1,Defaults(Table1_1),{ID:Value(Label2.Text)}) (ID:Number)

Best Regards.
Yumia

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Are you getting any changes at all in your Excel file, or just the ID that is not working?

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Do you format your excel as Table?

Could you please share screeshots of your example data source and the controls and their formula expressions in your app?

Best Regards.

Yumia

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I solved the issue by deleting the ID datacards I have been created more

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I solved the issue by deleting the ID datacards I have been created more

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Everyone,

I have a similar subject line but a different issue,, mine is that I'm also saving data into excel online on a column named ID and my formula to save is this:
Value(First(Sort(Table1,ID,Descending)).ID) + 1 // ( this is without any "IF" formulas )

but when it reaches 10.. It's stuck..

excel online
What am I doing wrong here?

Thanks.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Try replacing your formula with the following:

Max(Table1, ID) + 1

See if you experience any different results.

Also, make sure that your maximum records option in your Advanced Settings is not set low.

Was this reply helpful? Yes No