cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aurora
Helper V
Helper V

Can't update SharePoint column with Value from other SharePoint site

Hi all, 

 

I have an app that sends data to SharePoint. I have replaced the items of 2 comboboxes with lists of choices from another SharePoint list, but currently can only get one of the comboboxes to send its result to the SharePoint list that saves the data. The items are: 

 

DataCardValue13: Sort(Distinct('Engineering-Request Tests', Machine), Descending) 

DataCardValue12: Filter('Engineering-Request Tests', Machine = DataCardValue13.Selected.Result)

 

My update fields contain: 

For DataCardValue13: {Value:DataCardValue13.Selected.Result}

For DataCardValue12: {Value:DataCardValue12.Selected.Results}

 

The values from DataCardValue13 are properly sent to my SharePoint site, but so far I am unable to grab the value from DataCardValue12. Below is the list I am grabbing the data from, Title is related to DataCardValue12.

Aurora_0-1644941006622.png

 

Does anyone know if I need a different formula or solution to send the values to the proper place? 

1 ACCEPTED SOLUTION

Accepted Solutions

@WiZey 

 

The ComboBox was already set to only allow one selection. I do believe I got it to work now by changing the DataCardValue Update field to: {Value:DataCardValue12.Selected.Title}

 

The combobox grabs the "name" of each test that is run on each machine, so it only needed to grab a string of text for a name.

View solution in original post

2 REPLIES 2
WiZey
Super User
Super User

Hello @Aurora ,

 

Could you be more specific about the type of data you are trying to put inside DataCardValue12 ? 

 

If I'm not mistaken, you're trying to put a "Table" as a value inside your SharePoint list, and I'm not sure that is a good approach. 

 

If you wish to link multiple values to your row, you probably should create a "child" list to refer to the "mother" list. 

 

But if you're actually trying to insert a "string" value, then you should configure your combobox control and disable the "multiple selection" toggle. That way you will put only one selected item to your value instead of a table of selected items.

@WiZey 

 

The ComboBox was already set to only allow one selection. I do believe I got it to work now by changing the DataCardValue Update field to: {Value:DataCardValue12.Selected.Title}

 

The combobox grabs the "name" of each test that is run on each machine, so it only needed to grab a string of text for a name.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,339)