Data Table not Refreshing
Data Source = SQL Server 2016 Table called [Customer_Address] with PK = Cust_No
1) Text Box where user enters the Cust_No (e.g. 123456).
2) Data Table has:
Data Source [Customer_Address]
Data Table name = CustAdrs
Items = FILTER() cmd
** All addresses are displayed in Data Table for Cust_No 123456 - works great!
3) Several Text Boxes allow the User to enter a New Address and there is a BUTTON to "SAVE NEW ADDRESS".
The BUTTON issues several commands when clicked :
a) PATCH() cmd to write record to Customer_Address table - works great!
b) RESET() cmd clear out the address text boxes (used to enter the new address) - works great!
Issue * Data Table does not refresh
* Yellow triangle apear - "The Item has already been created on the server"
Is the Data Table Refresh issue resolved ?
Go to Solution.
I got the DATA TABLE to Refresh the data - I used REFRESH(The Sql View) ... not REFRESH(The Sql Table).
View solution in original post
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020