Unanswered

Error when referencing text label into combo box and Issue with patch function needing record instead of text

(0) Share

Report

Posted on by gadamcz

We have existing labels (B1, A10, B20, etc. )(Picture 1). When the user clicks a button in Pic 1, we want the combo box #2 on a separate screen (Pic 2) to populate with the label value in the same container as the button.

5 labels, 5 buttons next to it, one label equals one button. Combo box #2 has two properties: name and description.

Also, when we try to submit this information, the Patch function does not work because of an error saying it requires a Record instead of Text values.

Code below: (table name redacted)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @gadamcz

If you want Combo box #2 to be populated when specific buttons are clicked in the gallery, use a collection.
In the OnVisible property of the screen that contains the gallery:

Clear(col_SelectedRecs);

In the OnSelect property of the button in the gallery:

Collect( col_SelectedRecs, { Name: ThisItem.X, Description: "Whatever you want" } )

Where X is the value used to display B1, A10 etc

In Combo box #2 in the the other screen, the DefaultSelectedItems property is:
col_SelectedRecs
You're going to need additional logic to stop the user from clicking the same button twice in your gallery.

You should really ask your 2nd question in a separate post because it will be easier for members to find the solution to both of your questions if posted separately.

If this doesn't work, please post the 2nd part separately. Change the patch for 'Audit Area' to:
cmbAuditArea1.SelectedItems

Was this reply helpful? Yes No
NetraVenkatapat 4 on at

Like (0)

Report

@DJ_Jamba
Thanks for the reply. It worked until referencing the label to the combo box. My combo box has two fields, and I'm trying to create an empty record and patch the column with the name, area name, ..., but I have errors with 'Audit Area'. I tried using selected items as well with no luck.

Error - "The type of this argument 'Audit Area' does not match the expected type 'Record'. Found type 'Table'. The function 'Patch' has some invalid arguments."

TIA

Was this reply helpful? Yes No