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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,543)