Power Platform Community Forum Thread Details

Hello,

I have a canvas app with a data table. Data table’s data source is a CombinedData which is collected at the OnStart of the App, via ClearCollect of three separate but identical (columns etc) SharePoint lists. Everything works perfectly. When I try to use PATCH function to update a new text entered in a text box back to original data source (sharepoint list) i am having trouble. Here is the formula AI created. Technically, this looks like in line of what I need, but it does not work. This will give you idea of what I am trying to do. Basically, when a user selects a row on the data table, add a value to a TextInput box, click on this new button, I want that value to be posted to the hard coded column of the row. Again, formula shall tell you what I aim to do. Any help is appreciated.

If(
  CPTS_Dashboard_Table1.Selected[@SourceList] = "Tracker_PKA",
  Patch(
     Tracker_PKA,
     LookUp(Tracker_PKA, ID = CPTS_Dashboard_Table1.Selected.ID),
     { PRNumber: Text(TextInput1.Text) }
  ),
  CPTS_Dashboard_Table1.Selected[@SourceList] = "Tracker_PKB",
  Patch(
     Tracker_PKB,
     LookUp(Tracker_PKB, ID = CPTS_Dashboard_Table1.Selected.ID),
     { PRNumber: Text(TextInput1.Text) }
  ),
  CPTS_Dashboard_Table1.Selected[@SourceList] = "Tracker_PKC",
  Patch(
     Tracker_PKC,
     LookUp(Tracker_PKC, ID = CPTS_Dashboard_Table1.Selected.ID),
     { PRNumber: Text(TextInput1.Text) }
  )
);
Refresh(Tracker_PKA);
Refresh(Tracker_PKB);
Refresh(Tracker_PKC)