existing excel table without powerapps id

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,
I have an existing table with car numbers and the amount of times it has been washed, look at the following example.

Car	washedAmount
1	0
2	0
3	0

I just imported it into powerapps and want to be able to update the amount of times it has been washed as following.
I have a button with a onselect property

Set(numCar; txtCar.Text);;

UpdateContext({washed: LookUp(table1; (Car = numCar); washedAmount)});;


Update(table1; First(Filter(table1; Car = numCar)); {washedAmount: washed + 1});;

I am not sure if this code works because when i try to test it, it gives me a error that a powerappsid field is required. Can anyone help me? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

eka24 20,923 on at

Like (0)

Report

Are you connection the Excel from your onedrive or it was uploaded?

The excel should be in your onedrive.

Also Check the excel file in your onedrive if it has PowerappsID column which is automatically generated after you connect the excel.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No