Unable to patch records in sharepoint(multiselect choice column) from power apps tab list

(1) Share

Report

Posted on by Rajua

Hi,

I have modern form with tab list 1,2,3.In tablist 1 i have a combo boX with multiselect option which need to get patched in sharepoint where it is choice column with multiselect. on the submit button i have the below code.

   
    If(
    tablist1.Mode =tablist1.New,       
    Patch(
        Source,
        Defaults(Source),
     tablist1.Updates,    
               
        tablist2.Updates,
        tablist3.Updates
        
    ),
    tablist1.Mode = FormMode.Edit,
    Patch(
        source,
        LookUp(source,Description= tablist1.Updates.Description),
        tablist1.Updates,
       tablist2.Updates,
       tablist3.Updates
    )
);
 
I didn't get error when i keep the choice box in the share point as single select, but when i make the choice column of the share point column as multiselect i get the error while patching

Categories:

Using Apps Using Formulas

All responses (2)

Answers (0)

WarrenBelz 146,645 Most Valuable Professional on at

Like (1)

Report
Unable to patch records in sharepoint(multiselect choice column) from power apps tab list

Hi Rajua,

Firstly, I have suggestion on the code as below - it should patch to the matching ID if present, or create new record if nothing is returned, however this is not your issue here.
A Form.Updates command simply uses the Update of every Form's Data Cards to write the output of the control (I assume a Combo Box) to the relevant field. If you have not allowed Power Apps to re-create the Data Card since you changed the field type, the Update will be incorrect, so either delete it and re-insert it (then Power Apps will set the value correctly), or post (in Text please) the current Items and DisplayFields of the Combo Box and the Update of the Data Card.

With( { _ID: LookUp( Source, Description = tablist1.Updates.Description ).ID }, Patch( Source, {ID: _ID}, tablist1.Updates, tablist2.Updates, tablist3.Updates ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
Suggested answer

Michael E. Gernaey 41,007 Super User 2025 Season 1 on at

Like (0)

Report

Unable to patch records in sharepoint(multiselect choice column) from power apps tab list

Hi,

I do not see any errors here, I am sorry I cannot help you, except to say, patching a multi-select is significantly different than a single

Please share your code and share the error

Thanks