Why are gallery records not unique if ITEM property in text label or text input is used for other functions eg filter or concat, not "ThisItem"
Is there a solution??
Hi @Englishweb ,
Could you please share the formula that you use that causes this issue?
Thank you for replying
I'm pulling data from a combo box and using the concat function to combine 2 fields in a text label box:
The source of the combo box is a table of student names
The results from the text box are being sent to the excel data sheet cell Student1 (not the same table as the combobox datasource.
I'm trying to get the text box to update to show the data in the excel cell, for each record in the Gallery. Normally I would use ThisItem.Student1, but I can't because of the Concat function already in the text box.
The DataTable shows that it is patching back to the excel file, but the text box is not reflecting this change onscreen.
I hope this makes sense!