Saving a Collection to Sharepoint with numerical coloumns

[WB_Sharevision]

I have canvas app that collects data for a sharepoint list. To implement offline-caching I have created a colelction that stores the data from the form and uploads it later.

Collect(
ItemCache,
{
Title: DataCardValue9.Text,
OperatingHours: (Value(DataCardValue10.Text)),
NextInspection: InspectionDate.SelectedDate,
Servicerequired: DataCardValue12.Value,
Reason_x0020_for_x0020_service: ListBox1.SelectedItems,
Comments: DataCardValue14.Text

}
)

The text in red is causing issues (it seems) in the save:

Collect('mySharepointList',ItemCache)

If I don't use the "Value" I get a "incompatible type" error, if I use the "Value" I get an error "The specified couloumn "Value" does not exist"...

Any help would be appreciated.

[mdevaney]

@WB_Sharevision 

Hi there!  Your post mentioned some text highlighted in red.  However, I do not see any highlight text.  Could you please reply to this message and share the problematic code line?

Thanks 😄

[WB_Sharevision]

Sorry for B/W version, I fixed the original post to display the red line. 🙂

[mdevaney]

@WB_Sharevision 

I am reviewing your code and do not see any errors.  I'd like to ask a few questions.

• What is the full "incompatible error"?  It usually gives an expected type.
• When is ItemCache first Collected?  Can you share the code?
• What value are you inputting into DataCardValue10?  Please also take a screenshot of that input control

[WB_Sharevision]

@mdevaney  Sorry for the delay and thx for taking time for my problem.

DataCardValue10 is a textfield, but only expects numbers (Annotation 2019-10-15 073503.png). The full error is in ErrorMsg.png. It actually point to the "Collect" method with an underlined "ItemCache" in the Timer event.

ItemCache is initialized in the OnVisible of the StartScreen:

...
ClearCollect(ItemCache,true);LoadData(ItemCache,"ItemCache",true);
...

[mdevaney]

@WB_Sharevision 

Please show your code for the property in Timer2.OnTimerEnd (screenshot).  In your picture I can see you have an error due to a Text value being supplied.

Also, I find this code to be peculiar.  I am not familar with the technique of initializing a collection with a value of True.  Perhaps you can share more on your coding choice here.  Perhaps loading ItemCache with a single variable here and many columns elsewhere is confusing PowerApps

ClearCollect(ItemCache,true);

To clear an existing collection I would typically just use this

Clear(ItemCache); 

[WB_Sharevision · Accepted solution]

Somehow is missed the notification of your reply.

In the meantime I worked around the problem by changing the sharepoint coloumn to accept TEXT. Now it works... 😕