cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
warsongg00
Helper II
Helper II

weird issue with patch command and excel

i used this command Patch(Employees, Defaults(Employees), {Name: Name.Text, CivilID: CivilID.Text,
Email: EmailAddress.Text }) on button which saves data in excel, the delima is the i have my table created with 2000 rows

and when i started the app it saved the first data in row 2000 not in row 1

how can i fix this issue? i want powerapp to save data from row one in excel 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

@warsongg00 

 

Make sure your existing table has no data

Delete all rows and just keep the empty table  in the data source and then patch

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
RezaDorrani
Dual Super User II
Dual Super User II

@warsongg00 

 

Make sure your existing table has no data

Delete all rows and just keep the empty table  in the data source and then patch

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

did that still have this issue

Capture.PNG

v-siky-msft
Community Support
Community Support

Hi @warsongg00 ,

 

How do you connect to your excel? By OneDrive or statics Excel file?

 

I have made a test on my side, and reproduce your issue.

It seems that although 2000 rows in table are empty, they are considered null in powerapps, so these 2000 rows are still treated as rows containing data.

If you want to patch data from row1, you should make your table have only one blank row.Annotation 2019-10-08 164232.png

Best regards,

Sik

thanks it was my mistake, i selected all rows and clicked delete on keyboard, didnt right click and use delete rows command

its not working as i wanted it

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (66,402)