Houston Power Apps and Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
Expand all | Collapse all

PowerApps Patch/ Form Function

  • 1.  PowerApps Patch/ Form Function

    Posted Jul 11, 2019 05:58 PM



    Thank you in advance for any helps. I'm a newbie with PowerApps but eager to learn, I've been trying to find my solutions everywhere online but couldn't fix it, any suggest would be appreciated!

    I'm trying to have a submit button to Patch several ComboBox selection to a SharePoint list. My ComboBox dropdown is from another SP list.

    How should I set up TYPE in my SP list column? should it be Choice or Multiple lines of text?

    How should my Patch function be? 


    I know for Dropdown list is like below, not sure how with ComboBox...

    Patch('SP list', Defaults('SP list'), Column1: Dropdown1.Selected.Value})

    I've try to include ForAll but still doesn't work as well..



    Quynh Le

  • 2.  RE: PowerApps Patch/ Form Function

    Silver Contributor
    Posted Jul 12, 2019 08:54 AM
    It's not clear to me exactly what you are trying to do.  If the user selects multiple items in the combo box, should that generate multiple rows in the SP list or do you want to combine the multiple selections into a single comma-delimited value for SP?  For example, if your combo box is a list of states and the user selects NY, CA, and TX, do you want that stored as three rows in SP or one row that looks like: NY, CA, TX?

    Regarding setting up the SP list, I have had problems with using choice. If the values are text, I usually just use a single line of text.  I guess it depends on whether your users will be viewing the list directly in SP or only through the app.

    For combo boxes, you might want to check out these videos: https://www.youtube.com/watch?v=pjs0ZsnJZXo and https://youtu.be/gsk14D-CYRE.

    Larry Burgess
    Interlinc Mortgage Services
    Houston TX