cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ebraga
Helper III
Helper III

Text Input missing from Collection

Hello All,

 

I have a gallery pulling from SQL. The user searches the gallery, selects an item with the checkbox, and then updates the "Quantity Requested" text input. The checkbox adds the line to a collection that will be pushed to a sharepoint list. (The text input "Qty Requested" is not being pulled from SQL.) When I select an item, the Qty Requested shows up in the collection but for some reason the value itself is not present. What am I doing wrong?

 

This is the onselect of the check box: Collect(colResults {itemnmbr:ThisItem.itemnmbr,lotnumbr:ThisItem.lotnumbr,QtyAvailable:ThisItem.QtyAvailable,bin:ThisItem.bin,QuantityType:ThisItem.QuantityType,QtyRequested:QtyRequested.Text})

1 ACCEPTED SOLUTION

Accepted Solutions
ebraga
Helper III
Helper III

I found the solution: the qty requested text input has to be completed BEFORE the check box selection. if the text input is updated after the check box selection, it does not bring forth the value to the collection  

View solution in original post

5 REPLIES 5
WarrenBelz
Super User
Super User

Hi @ebraga ,

You need to change text to a value

Collect(
   colResults 
   {
      itemnmbr:ThisItem.itemnmbr,
      lotnumbr:ThisItem.lotnumbr,
      QtyAvailable:ThisItem.QtyAvailable,
      bin:ThisItem.bin,
      QuantityType:ThisItem.QuantityType,
      QtyRequested:Value(QtyRequested.Text)
   }
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thank you for your help! I tried using the code you provided but unfortunately, no matter what value I enter for the text input it is only showing "0" for Qty Requested in the collection. 

RandyHayes
Super User
Super User

@ebraga 

Does your QtyRequested control happen to be in a Gallery?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Yes it is!

ebraga
Helper III
Helper III

I found the solution: the qty requested text input has to be completed BEFORE the check box selection. if the text input is updated after the check box selection, it does not bring forth the value to the collection  

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (5,571)