cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Data Table not Refreshing (Data Source = SQL Server 2016 DB Table)

Data Table not Refreshing Smiley Sad

 

Data Source = SQL Server 2016 Table called [Customer_Address] with PK = Cust_No

 

Have :

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!  Smiley Happy

 

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!  Smiley Happy

    b) RESET() cmd clear out the address text boxes (used to enter the new address) - works great! Smiley Happy

    c) REFRESH([CustAdrs])   

 

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Data Table not Refreshing (Data Source = SQL Server 2016 DB Table)

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

1 REPLY 1

Re: Data Table not Refreshing (Data Source = SQL Server 2016 DB Table)

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,432)