Hello,
I'm using a new pattern for Form building and could use some help on a ForAll function.
Goal:
- To Concatenate items in colSelectedResponses Collection which have the same ID and Patch them to the data source.
- Example: The two items below where id = 2 need to be concatenated and Patched to the data source as "Hammer; Ball Peen"
Scenario:
- Variable created from a table of data
Set( varItems, Table( {id: 1, item: "Wrench"}, {id: 2, item: "Hammer"}, {id: 2, item: "Ball Peen"}, {id: 3, item: "Screwdriver"} ) )
- Gallery with Checkbox controls. Items Property set to varItems
- OnCheck of Checkbox
Collect( colSelectedResponses, { id: ThisItem.id, value: component_checkbox.Text } )
- Button to Patch values has OnSelect Property set to:
Patch(dataSource, Defaults(dataSource), { dataSourceColumn1: LookUp(colSelectedResponses, id = 1, value), dataSourceColumn2: ForAll( Filter(colSelectedResponses, id = 2), Concatenate(value, ";") ), dataSourceColumn3: LookUp(colSelectedResponses, id = 3, value), } )
- The ForAll is not correct syntax.
Any help is appreciated!
Thank you
Solved! Go to Solution.
Figured it out with some help from @KickingApps!
Concat(Filter(colSelectedResponses, id = 31), value, "; ")
Yay!
Anyone want to take a stab at this one? Its kind of holding me up right now... ugh!
Figured it out with some help from @KickingApps!
Concat(Filter(colSelectedResponses, id = 31), value, "; ")
Yay!
User | Count |
---|---|
140 | |
136 | |
77 | |
76 | |
69 |
User | Count |
---|---|
224 | |
186 | |
68 | |
64 | |
57 |