cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maries1986
Helper IV
Helper IV

Updating a combo box to sharepoint look up

Hi!

 

Does anyone know why this wont return the datacardvalue on update

 

maries1986_0-1633362350337.png

 

 

Just says Table?  it worked before but stopped working.  it wont update...change or put the default it 

12 REPLIES 12
maries1986
Helper IV
Helper IV

I also need help with the dault value 

 

maries1986_0-1633363285727.png

 

StalinPonnusamy
Community Champion
Community Champion

Hi @maries1986 

 

Is the Lookup you are trying to update is single or multi-selection?

 

if it's single selection

Event : {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: DataCardValue60.Selected.Id,
            Value: DataCardValue60.Selected.Value
        }

If it's Multeselect column in SP then

 

Event: ForAll(
            DataCardValue60.SelectedItems,
            {
                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                Id: Id,
                Value: Value
            }
        )
maries1986
Helper IV
Helper IV

@StalinPonnusamy 

 

Hi 

 

Thanks for the response.  What do you mean by Event?

 

maries1986
Helper IV
Helper IV

It is single selection.  

maries1986
Helper IV
Helper IV

I tried this:-

Red under ID and Value 

 {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            Id: DataCardValue60.Selected.Id,
            Value: DataCardValue60.Selected.Value
        }

 I think the problem is more SP.......i need it to be able to have a blank value

StalinPonnusamy
Community Champion
Community Champion

Hi @maries1986 

 

  • What you are getting after DataCardValue60.Selected.?
  • Event is the Lookup Column Name in SharePoint

I assume you are having an issue with the patch command. Please share your complete patch command. You may remove any sensitive data.

 

maries1986
Helper IV
Helper IV

maries1986_0-1633382663844.png

 

Seems to be okay after from the :

 

Thanks for the help

StalinPonnusamy
Community Champion
Community Champion

Hi @maries1986 

 

Where exactly you are using this code? Thisitem.'Parent Host" should be just a ColumnName. So you may need to remove the Thisitem.

 

maries1986
Helper IV
Helper IV

in the Update:-  

 

'Parent Host':{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: DataCardValue60.Selected.Id,
Value: DataCardValue60.Selected.Value
}

 

Error is under Parent Host:

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,911)