error while any assigning collection

(0) Share

Report

Posted on by yougan

262

While assigning a collection giving below error.

in case if collection is not created yet, do we need to create a collection and execute this formulae?

If yes with how we need to creation collection. Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue has to do with workinghours, is it a name of a textbox or name of a collection?
Collect(workinghours,{Name:NameTextInput.Text,Hour: workinghours.Text})
So try:
Collect(workinghoursTable,{Name:NameTextInput.Text,Hour: workinghours.Text})
if workinghours is not a textbox, replace it with the name of the textbox on your form
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello is the issue Resolved
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
yougan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I tired as you have suggested.
Please refer attached screenshots.
workinghourstable -->collector name
in case if I still I get the error, does it mean I should have created collector before? if yes how? Please help.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use
Collect(workinghoursTable,{Name:NameTextInput.Text,Hour: WorkingHoursText.Text})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
yougan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Thank you for your time.
But no luck. I have attached screenshots showing errors.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Change the collection name. Also can you use a button instead of the triangle.

Collect(workinghoursTable2,{Name:NameTextInput.Text,Hour: WorkingHoursText.Text})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
yougan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

still same.
Where I have used triangle? are you referring rectangle?

I have attached screenshots
If possible can we have a screen sharing now? Thank you.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I have seen the problem:
Follow this;
Insert 2 new Textboxes and let call it TextboxA and TextboxB.

Then use the formula as follows;
Collect(workinghoursTable2,{Name:TextboxA.Text,Hour:TextboxB.Text})

The issue is that what you have named as TexInputText is a rectangle not a Textbox. You cannot type or enter anything Ina rectangle. You have to use a Textbox.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
yougan 262 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Eka,

still it is not working for me. Not sure where I was doing wrong.
Please find attached screenshots.

Thank you.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What you have shown is a label not a Textbox. To insert a text, look at the picture you sent, on the insert tab, look down and go to Text.
Select the Text, it will give you options including Textinput. Click on Textinput. That would insert a Textbox. Am not on my machine I would have given a picture.
https://youtu.be/PC7pddoqluo

After watching, go to my reply before this one.
If you have issues on Textinput watch this on how to insert Textbox or Textinput

Was this reply helpful? Yes No