cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WB_Sharevision
Level: Powered On

Saving a Collection to Sharepoint with numerical coloumns

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
WB_Sharevision
Level: Powered On

Re: Saving a Collection to Sharepoint with numerical coloumns

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... 😕

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Saving a Collection to Sharepoint with numerical coloumns

@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
Level: Powered On

Re: Saving a Collection to Sharepoint with numerical coloumns

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

Super User
Super User

Re: Saving a Collection to Sharepoint with numerical coloumns

@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
Level: Powered On

Re: Saving a Collection to Sharepoint with numerical coloumns

@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);
...
Super User
Super User

Re: Saving a Collection to Sharepoint with numerical coloumns

@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); 
Highlighted
WB_Sharevision
Level: Powered On

Re: Saving a Collection to Sharepoint with numerical coloumns

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... 😕

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,982)