Hello,
Quick question here?
I am having some hard time with my clearcollect function.
What I am trying to do is create a collection from a gallery, I am using the following formula:
ClearCollect(
SendtoFlow,
ShowColumns(
Gallery7.AllItems,
"Title",
"Item",
"UoM",
"Price",
"Quantity",
"LocationID"
),
{Customer: ComboBox3.Selected.Title},
{State: Label12_1.Text},
{POSNumber: Label12_2.Text},
{Quotation: Label12_3.Text}
)
These columns are for a different records like a purchase order style:
"Title", "Item", "UoM", "Price", "Quantity", "LocationID"
And this ones are for a one time use, like a purchase order header:
{Customer: ComboBox3.Selected.Title}, {State: Label12_1.Text}, {POSNumber: Label12_2.Text}, {Quotation: Label12_3.Text}, so this fields are outside of my Gallery7. But I was OK to retrieve in the formula.
Now I have a bad boy "Text Tield", and I am trying to retrieve inside the Gallery7 using a LookUp condition:
LookUp(Database,Lblitem.Text=ItemNumber,Description)
The reason why is because is a huge amount of text and I don' want to save it every time I have to create a Purchase Order.
Now Everything is fine until the point that I want to ADD that field to my Clear collect, once I have the description added I got an error and the Set JSON is not working also.
ClearCollect(
SendtoFlow,
ShowColumns(
Gallery7.AllItems,
"Title",
"BidItem",
"UoM",
"Price",
"Quantity",
"BuildingID",
"LblDescription"
),
Any idea?
Thanks in advance
