Form behavior with SharePoint List connector

I'm currently working on an app which basically allows users to create tickets. As there might be a lot of tickets I couldn't use Excel and migrated to Sharepoint due to row limitation. (Basically using Sharepoint as a database)

The app is made of forms which allow to create/edit tickets.

When i create a new ticket using the creation form the Sharepoint List that stores this info does not update.

This is why I'm wondering what type of interactions does the app have with Sharepoint? (what i've seen so far makes me think it's a Read-Only mode)

I have tried doing some research on this issue but I only see the Powerapps Integration to Sharepoint which isn't what I'm looking for.

Re: Form behavior with SharePoint List connector

- You have too many rows (by the way I think an Excel file can have more data than a list, no ?)

At the moment I have a very light database since I'm developping the app (less than 20 rows in each list)

Unfortunatelly due to the limitations of PowerApps he cannot treat more than 500 rows in an Excel (2000 in experimental). This is why I switched to sharepoint which allows Powerapps to delegates its search functions. Instead of Powerapps doing the research he just sends the search informations to Sharepoint which sends back the results.

- You haven't rights to update your data in your list

New rows are created but they are empty this is why I don't really get why it would be rights (I assume if Powerapps can create a line he can also add data to the created line?)

Thank you for your time!

(Btw your english is pretty good don't excuse yourself for speaking at least two languages )

basefa is the Sharepointlist where the general ticket information ios stored, idfa is the column which corresponds to each ticket's ID, lastidfa and varidfa allow me to get the last id and increment it by 1, Form1 is the form which allows me to submit the new ticket ID (in case multiple users create one in a short time) to the database (here the basefa SP list) before moving to the next screen, AjoutFA is the screen where the new ticket is created, all the NewForms are a way to set by default all the forms on AjoutFA to New mode.

If the code's characters such as ";" seem weird to use, my powerapps is by default in French and this is how we have to code it.

Once I press the button the Form1 uses the right ID then moves to the new screen but here is the result in sharepoint:

The blue marked line is the one created when pressing the button th black one is the ones that already existed.

Basically for every form that i use in the standalone app all it does is create an empty line in the corresponding sharepoint list

Re: Form behavior with SharePoint List connector

I created a standalone app to which I added some Sharepoint Lists as Datasources. Just like I would do for Excel tables I created some forms to create and edit lines. Here is where my problems pop up : the line gets created but is empty and I can't edit any lines.

Am I missing something to be able to freely edit the sharepoint lists like you would do with Excel tables?