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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 155,996 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No