0

Please help, I am rather new to PowerApp, but it follows a similar concept to C# in Visual Studio IDE. I am building a custom PowerApp that pulls and stores data in Excel files (.xlsx) and stored in OneDrive. It has no issues when trying to save other data, just ProdName. It will save Quantity, Record Create Timestamp, Record Create User, and the location...but not Product.

I have pulled the Patch() from known good code. I have tried saving to a fresh tab in the existing spreadsheet. I have tried saving to a fresh table in a brand new spreadsheet. I have tried saving other data in the Product field (Quantity and Location). Nothing seems to be making any difference.

Here is the Patch() statement I am using.

Patch(Inventory, {ProdName:ListBox1.SelectedText.Value}, { Quantity:TextInput2.Text}, {Location:ListBox1.SelectedText.Value} ,  { RCD:Now()}, { RCU:User().Email}); Notify("Success",Success)

Here is the excel file I am trying to save the inventory data to. Inventory Excel File

Here are the source lists that are loaded into ComboBox and ListBox objects. Source Data Excel for Objects

Gerry Zapantis
  • 1
  • It's almost like it's ignoring the ProdName field and moving to Quantity. I moved quantity to the front of the Patch statement, and ProdName came through, but Quantity did not. – Gerry Zapantis Jan 17 '23 at 17:38

0 Answers0