Unanswered

Error message in ClearCollect - Incompatible type - The collection can't contain values of this type

(0) Share

Report

Posted on by bobgodin

380

@WarrenBelz Hi Warren since I resolved my previous post a collection that I am using elsewhere in the app is complaining that it "can't contain values of this type" - is this because I added the ID field to the Gallery - how do I fix this problem please?

This is the code I have:

ClearCollect(
 collDetails,
 ForAll(
 Sequence(CountRows(Gallery6_4.AllItems)),
 Patch(
 Last(
 FirstN(
 Gallery6_4.AllItems,
 Value
 )
 ),
 {RowNumber: Value}
 )
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bobgodin ,

I just ran that code on a gallery here (base on an SP list) and received the expected result (the list with the added RowNo number field). What are the Items of the gallery and where are you running that code ?

Was this reply helpful? Yes No
bobgodin 380 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz thanks you for your response. I have solved it - I had added the ID field into the Gallery and this was what the ClearCollect was unhappy about - once I removed it and re-added the original code you gave me with my modifcations it was happy.

what's working now for me:
Patch( TripDetails, ForAll( Gallery6_4.AllItems As _item, With( { _ID: LookUp( TripDetails, ID = Value(_item.ID) ).ID }, { ID: _ID, tripid: Value(_item.TextInput2_26.Text), tripdate: DateValue(_item.DatePicker1_1.SelectedDate), destination: _item.TextInput2_25.Text, activity: _item.TextInput2_27.Text, localcontact: _item.TextInput2_28.Text, accomodation: _item.TextInput2_29.Text, callintimes: _item.TextInput2_30.Text, hoursworked: _item.TextInput2_31.Text } ) ) ));
thanks again for the help 🙂

Was this reply helpful? Yes No