web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
You're Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Apps - Webinars and Video Gallery / Friday Functions Community ...

Friday Functions Community Tags : Use lookups to save multiple selections in Excel using PowerApps

Views (629)
Audrie101 Profile Picture Posted by Audrie101 Microsoft Employee

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.

daniel2.PNG

Categories:

Comments

  • darogael Profile Picture darogael 123 Most Valuable Professional
    Posted at
    Friday Functions Community Tags : Use lookups to save multiple selections in Excel using PowerAp

    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.

  • SandyU Profile Picture SandyU 225
    Posted at
    Friday Functions Community Tags : Use lookups to save multiple selections in Excel using PowerAp

    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