Unanswered

ID Value not showing in Table

(1) Share

Report

Posted on by ShogunMorty

Hi Guys,

im having a problem regarding showing ID values in a table in power apps.
Im using a forms to send data to a sharepoint list.
There im using the already existing column called ID to store the id.
When i create a item via the sharepoint list, the ID is shown in my table

but when i create it directly in my app the id column stays empty.
Also i tried to include the ID column in my send forms page

and currently this is on the on select part of my send button:

SubmitForm(FormEintragErstellen);

If(FormEintragErstellen.Error=Blank(),

Refresh(Ausbildungsbudget);

Set(verShowPopup,false);

Set(varShowPopupSuccess2, true),

Notify("Fehler beim Absenden der Form. Bitte alle rot markierten Felder ausfüllen.", NotificationType.Error)

)

What am i doing wrong?

I'd really appreciate it if one could help me out on this, thanks in advance!

All responses (2)

Answers (0)

ShogunMorty 24 on at

Like (0)

Report

Re: ID Value not showing in Table

I dont get what you mean with putting it on the "on success part" since currently the code for sending my forms
is on the on select part of the create button. I still tried removing the refresh part from there and ad it into my success popup screen but still no solution. It shouldn't be a timing or refresh issue cause even if you reopen the app or refresh the data source manually via my refresh button it still doesnt show the ID of a item created in the power app.
The ID is only shown in my app table when i create a item via the data source (share point list). Then it works properly. So my guess would be that it has to do with the create forms part. I also tried adding the "ID" datacard in the send forms window but make it invisible play with the default value, so it gets auto filled but i cant get this to work out.
I've added pictures of my data source and every other relevant part.
Michael E. Gernaey 40,481 Super User 2025 Season 1 on at

Like (0)

Report
Re: ID Value not showing in Table

HI @ShogunMorty

1. Can you verify that in the back end the rows are getting an ID? Its auto, so it should

2. Can you please share the code that is loading the data please

You said this is in the OnSelect, but if you have code after a FormSubmit, it should be on the OnSuccess or the OnError of the Form, not immediately after.

So if the data is in the back end but no in front, I believe its a timing issue because you are refreshing too soon.

SubmitForm(FormEintragErstellen); If(FormEintragErstellen.Error=Blank(), Refresh(Ausbildungsbudget); Set(verShowPopup,false); Set(varShowPopupSuccess2, true), Notify("Fehler beim Absenden der Form. Bitte alle rot markierten Felder ausfüllen.", NotificationType.Error)

Move your code into the OnSuccess of the FormSubmit, and let me know how it goes after that.

Also, share your DataSource that you are using for the "Table"

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey