All,
I have been struggling to code the following scenario. I consider myself a newbie and my knowledge of powerapps is very limited. So, any hint is appreciated.
I followed the following posts - which helped me, however requirements chagned.
I have a galllery that is coneccted to a SP table with 2 columns
Taks Name, Task Ticket.
1) I need to findout which toggles are true representing each task and Task Ticket (if i am using ForAll). How can I identify those toggled items (Toggles dont seem to have "name" property associated with them) and couldn't identify them.
2) how can I concenate them to make a single long string Outside of the gallery that can be displayed in a text box. I tried to use Collection in case, one of the toggles are unselected, however my collection keeps increasing. Couldn't get remove working.
Any hint / example is greatly appreciated.
thanks
on OnSelect of the toggle within the gallery If( Toggle4.Value = true, Collect(CheckCollection, { TaskName: ThisItem.Name } ))
I also have
ForAll( Filter(Gallery1.AllItems, Toggle4.Value = true), Collect(CheckCollection, 'Task Name' ) );
Solved! Go to Solution.
@Anonymous
Ok, so you mention two fields/columns - Task Name and Task Ticket
I am going to assume from that the toggles are not part of any field or column of importance.
Also, you only mentioned a single string for all the items checked - I am going to assume a comma separated list of Task Name - Task Ticket
Also assuming that Task Ticket is a text column.
With all those assumptions, what you are looking for is this formula:
Concat(Filter(yourGalleryName.AllItems, yourToggleName.Value), TaskName & " - " & TaskTicket & ", ")
Substitute your control names and your Column names in the red items above.
That should give you the string of all selected (checked) items in your Gallery.
Hope that helps.
@Anonymous
Can you explain what you are referring to with the toggles?
You mentioned you had two columns - Task Name and Task Ticket
So what is the toggle and what is it tied to?
Hi Randy,
Thanks for replying. basically it is a set of tasks that have to be tested every morning. If one of them is failed, we need to toggle the corresponding toggle control to failed / false. similar to the first link except with toggle instead of checkboxes. How can I show what is selected outside gallery using label and if unselected, drop it from the selected list / label value.
do I make any sense?
Guldf_Man
@Anonymous
Ok, so you mention two fields/columns - Task Name and Task Ticket
I am going to assume from that the toggles are not part of any field or column of importance.
Also, you only mentioned a single string for all the items checked - I am going to assume a comma separated list of Task Name - Task Ticket
Also assuming that Task Ticket is a text column.
With all those assumptions, what you are looking for is this formula:
Concat(Filter(yourGalleryName.AllItems, yourToggleName.Value), TaskName & " - " & TaskTicket & ", ")
Substitute your control names and your Column names in the red items above.
That should give you the string of all selected (checked) items in your Gallery.
Hope that helps.
Thank you Randy. continuing with my dev till another issue pops....
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
187 | |
83 | |
52 | |
37 |
User | Count |
---|---|
288 | |
245 | |
119 | |
77 | |
56 |