12-04-2017 14:14 PM - last edited 12-05-2017 09:24 AM
This video provides a step-by-step tutorial on how to lookup columns from an Excel spreadsheet saved on OneDrive and save the multiple selected values back to Excel using PowerApps. #FridayFunctions and #PowerApps.
watch?v=PebzQcpmQJc
https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPebzQcpmQJc
Hi @darogael
I'm unclear what you're doing with the Left and Len (and then -1)... Can you please describe that a bit? (Unless I missed something in the video...?) Does it have something to do with how the combo box stores values? I mean, I understand how those functions work in general, but I'm unclear how you're using them.
Thanks!
Sandy
Proud to be a Flownaut!
Hi Sandy,
Yes, this formula and it's syntax is used to save multiple selected values from a combox box control to a single line of text with a semi-colon. The first selection on the top of the combo box is the first text value on the left. A little convoluted but it works.