cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Englishweb Post Patron
Post Patron

gallery records not unique if label item property is used for other functions - Help!

Hello

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??

Thanks

3 REPLIES 3
Community Support
Community Support

Re: gallery records not unique if label item property is used for other functions - Help!

Hi @Englishweb ,

 

Could you please share the formula that you use that causes this issue?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Englishweb Post Patron
Post Patron

Re: gallery records not unique if label item property is used for other functions - Help!

Hello @v-monli-msft 

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!

Englishweb Post Patron
Post Patron

Re: gallery records not unique if label item property is used for other functions - Help!

Sorry the image didn't load

Concat(S1Combo.SelectedItems, PRENOM & " " & NOM ",")textbox function.png

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (9,787)