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 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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,930)