Error when using the collect function: the value must be between 0 and 100

(0) Share

Report

Posted on by Jplm6

help!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

LowCodeJim 314 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you post the collect statement you are using as well as information about the data source? As a guess it sounds like you may be trying update something that has a restriction about what data can be used (e.g. a SP number column with a min and max set as 0 and 100.

Was this reply helpful? Yes No
Jplm6 6 on at

Like (0)

Report
Copy link

Link copied!

Collect(
'SGF Checklist';
{
Id: GUID();
Observação: TextInput1.Text;
Resultado: DropdownCanvas1.Selected.Value;
Item: Label52.Text;
Tipo: Label51.Text
});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação: TextInput2.Text;
Resultado: DropdownCanvas2.Selected.Value;
Item: Label53.Text;
Tipo: Label51.Text
});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação: TextInput3.Text;
Resultado: DropdownCanvas3.Selected.Value;
Item:Label54.Text;
Tipo: Label51.Text
});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação:TextInput4.Text;
Resultado: DropdownCanvas4.Selected.Value;
Item:Label55.Text;
Tipo: Label51.Text

});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação:TextInput5.Text;
Resultado: DropdownCanvas5.Selected.Value;
Item:Label56.Text;
Tipo:Label51.Text
});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação:TextInput6.Text;
Resultado:DropdownCanvas6.Selected.Value;
Item:Label57.Text;
Tipo:Label51.Text
});;
Collect(
'SGF Checklist';
{
Id:GUID();
Observação:TextInput7.Text;
Resultado:DropdownCanvas7.Selected.Value;
Item:Label58.Text;
Tipo:Label51.Text
})

Was this reply helpful? Yes No
LowCodeJim 314 Moderator on at

Like (0)

Report
Copy link

Link copied!
OK, are you able to tell me anything about the datasource "SGF Checklist"? Also with the collect function you can collect multiple records at once rather than having to write multiple collect statements.
Collect( 'SGF Checklist'; { Id: GUID(); Observação: TextInput1.Text; Resultado: DropdownCanvas1.Selected.Value; Item: Label52.Text; Tipo: Label51.Text }; { Id:GUID(); Observação: TextInput2.Text; Resultado: DropdownCanvas2.Selected.Value; Item: Label53.Text; Tipo: Label51.Text }; { Id:GUID(); Observação: TextInput3.Text; Resultado: DropdownCanvas3.Selected.Value; Item:Label54.Text; Tipo: Label51.Text }; { Id:GUID(); Observação:TextInput4.Text; Resultado: DropdownCanvas4.Selected.Value; Item:Label55.Text; Tipo: Label51.Text }; { Id:GUID(); Observação:TextInput5.Text; Resultado: DropdownCanvas5.Selected.Value; Item:Label56.Text; Tipo:Label51.Text }; { Id:GUID(); Observação:TextInput6.Text; Resultado:DropdownCanvas6.Selected.Value; Item:Label57.Text; Tipo:Label51.Text }; { Id:GUID(); Observação:TextInput7.Text; Resultado:DropdownCanvas7.Selected.Value; Item:Label58.Text; Tipo:Label51.Text })
Apologies if the semi colons are not quite right, I am used to using commas. Does the error appear when you type the formula or when you run it?

Was this reply helpful? Yes No
Jplm6 6 on at

Like (0)

Report
Copy link

Link copied!

It appears when I run it.

Was this reply helpful? Yes No
LowCodeJim 314 Moderator on at

Like (0)

Report
Copy link

Link copied!

And what is the data source "SGF Checklist"? A SharePoint list?

Was this reply helpful? Yes No
Jplm6 6 on at

Like (0)

Report
Copy link

Link copied!

Dataverse table

Was this reply helpful? Yes No
LowCodeJim 314 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ah ok, maybe you need to increase the max length of your text fields? By default a dataverse Text/Text area max length is 100 characters
Can you check your column settings for Observação, Item and Tipo. I suspect you need to increase one of these.

Was this reply helpful? Yes No