Unanswered

How to save/update dropdown and multi lookup value to SharePoint list

(0) Share

Report

Posted on by appuser5

1. I have a collection, that is displaying value as dropdown binds in the items of dropdown

2. Items- Filter(EntityFilter, Default_YN=true).Title
Entity filter is a collection, because true or false not working as expected. so did a collection and filter values based on that.
DefaultSelectedItems value is set as- EntityFilter.ID

3.In DataCard -update, using below code

DataCard -update- ddlEntity.SelectedItems

Need a help on below,

I have a patch and try to update, the below code, but it fails

Patch(MainList,
Defaults(MainList),
{
Entity:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:ddlEntity.SelectedItems,
Value:""}
}
)

I assume in selected item of odata, we need to pass id, but dont know how to pass the id.

Step:5

In the same way i have multi lookup to save in to sharepoint list- do share some light on it.

a. In start up of - setting lookup by filtering data.

b.In screen visible i am setting the below code in collection

c.And binding the value dpssExemptedYes in Items of the control

Patch(
MainList,
Defaults(MainList),
{
Title:lblTitle,
DPSSExemptedList:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:dpssExemptedYes,
Value:""
}
}

)

Can anyone assist me to save multi lookup values to list

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@appuser5
For your first problem
What is the data source of EntityFilter collection? from Entity list?
Which column does the Entity column in Mainlist look up to? Title?
If my assumptions are right.
1. Modify the Items property of ddlEntity:

Filter(EntityFilter, Default_YN=true)

2. Modify the patch function as below:

Clear(Col);ForAll(ddlEntity.SelectedItems, Collect(Col,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:ID, Value:Title})); Patch(MainList, Defaults(MainList), {Title:"Test", Entity: Col })

For your second problem
1. Remove '.Title' in OnVisible property
2. Modify the Patch function

Clear(Col2); ForAll(dpssExemptedYes, Collect(Col2,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:ID, Value:Title})); Patch( MainList, Defaults(MainList), {Title:lblTitle, DPSSExemptedList: Col2})

Sik
appuser5 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Which column does the Entity column in Mainlist look up to- I am getting Entity from Lookup column and place it in a collection called Entity Filter.

I have a clarification, do you setting up a collection Col to entity filter or creating new collection and assign to 'odata:', so the collection contains the id to pass value, right?
I will work it out and get back
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@appuser5
I mean what is the related column of your Entity column(LookUP)?
To patch LookUp field of SharePoint, you have to patch a record containing '@odata.type', Id and Value.
Id is the related record ID, and Value is the related column.

Also, could you share the Formula you used to generate EntityFilter collection?
Sik