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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

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 (1,745)