Hi all
Hope someone can help or point me in the right direction.
A collection is created called ServerListCollection based on a number input field called TotalServersInput with the following code...
ClearCollect(ServerListCollection, {});
ForAll(
Sequence(Value(TotalServersInput.Text)),
Collect(ServerListCollection, { Value: Text(Value) })
);
ServerListCollection
This works a treat, but I want to convert all the numbers in this list into text strings. I have jumbled together the following code, but I cannot get it working for my poor brain. I've confirmed that the TotalServersInput text field is formatted as a number and can see the name of the single column in the collection is called Value.
ClearCollect(ServerListCollection, {});
ForAll(
Sequence(Value(TotalServersInput.Text)),
Collect(ServerListCollection, { Value: Text(Value) })
);
ForAll(
ServerListCollection,
// Data(ServerListCollection),
UpdateIf(
ServerListCollection,
Value in Value(ServerListCollection),
{
Value: Text("server" & Text(Value))
}
)
);
ServerListCollection
This is the error Power Apps is giving me...
"Expected text or number. We expect text or a number at this point in the formula. This error will occur if you use a function that requires either text or a number but you supply, for example, a boolean value."
I am wondering how I can fix the code, please help!
