I built a canvas PowerApps that is working nicely with one exception. I have a Patch function to update the SharePoint list. It works great for text fields, but for number fields I get an error message: Type of argument does not match expected type 'Number'. Found type 'Text'. I have tried '.Text', '.Value', and '.Number', before and after the field and nothing works. The data type in the source data is number. Any ideas on what have I done wrong and how I can fix the issue? I know the field and control names are in the correct order because I tested the same function on a field with a text value.
OnSelect: Patch(WeeklyTracker_2,ThisItem,{ATBRev:txtATBRev.Text})
Any assistance is greatly appreciated! Thank you
Solved! Go to Solution.
Are you stating that ATBRev is a numeric column? If so then change your formula to the following:
Patch(WeeklyTracker_2,ThisItem,{ATBRev: Value(txtATBRev.Text)})
I hope this is helpful for you.
Are you stating that ATBRev is a numeric column? If so then change your formula to the following:
Patch(WeeklyTracker_2,ThisItem,{ATBRev: Value(txtATBRev.Text)})
I hope this is helpful for you.
Thank you SO much