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!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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