I have added lookup column to List 'B' from List 'A' ID. Lookup column name is 'ProjectID'. But when I am patching it is not recognizing the 'ProjectID'. Error saying `The Specified column 'ProjectID' does not exists`
ForAll(MileStoneCollection,Patch(Milestones,Defaults(Milestones),
{Title:MileStoneTitle,Projected_x0020_Date:ProjectedDate,
Completed_x0020_Date:CompletedDate,ProjetID:CurrentItem.ID}))
I also tried this too... How to patch this?
ForAll(MileStoneCollection,Patch(Milestones,Defaults(Milestones),
{Title:MileStoneTitle,
Projected_x0020_Date:ProjectedDate,
Completed_x0020_Date:CompletedDate,
ProjetID:{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:CurrentItem.ID,
Value:CurrentItem.ID}))
UPDATE:
If I remove ProjectID from Pathch, It is saying ProjectID is requiredfield. I don't know where to add this.
Solved! Go to Solution.
Hi @Itsmesri,
Could you please share a bit more about the CurrentItem that you mentioned within your formula?
Do you want to set a value for the LookUp column of your List B within the Patch formula?
Which value do you want to set
If you want to set a value for the LookUp column of your List B within the Patch formula, please take a try with the following workaround:
Modify your formula as below:
ForAll(
MileStoneCollection,
Patch(
Milestones,
Defaults(Milestones), {
Title: MileStoneTitle, Projected_x0020_Date: ProjectedDate, Completed_x0020_Date: CompletedDate, ProjetID:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp('YourListA',ID= CurrentItem.ID, ID), /* <-- Search the corresponding ID related to the saved value within your List A */ Value: CurrentItem.ID /* <-- type the value you want to save into the LookUp column*/
}
} /* <-- don't miss this } character here */
)
)
More details about set a value for a LookUp column of a SP list, please check and see if my response within the following article would help in your scenario:
https://powerusers.microsoft.com/t5/Creating-Apps/Default-Dropdown/m-p/159618
Best regards,
Kris
Hi @Itsmesri,
Could you please share a bit more about the CurrentItem that you mentioned within your formula?
Do you want to set a value for the LookUp column of your List B within the Patch formula?
Which value do you want to set
If you want to set a value for the LookUp column of your List B within the Patch formula, please take a try with the following workaround:
Modify your formula as below:
ForAll(
MileStoneCollection,
Patch(
Milestones,
Defaults(Milestones), {
Title: MileStoneTitle, Projected_x0020_Date: ProjectedDate, Completed_x0020_Date: CompletedDate, ProjetID:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp('YourListA',ID= CurrentItem.ID, ID), /* <-- Search the corresponding ID related to the saved value within your List A */ Value: CurrentItem.ID /* <-- type the value you want to save into the LookUp column*/
}
} /* <-- don't miss this } character here */
)
)
More details about set a value for a LookUp column of a SP list, please check and see if my response within the following article would help in your scenario:
https://powerusers.microsoft.com/t5/Creating-Apps/Default-Dropdown/m-p/159618
Best regards,
Kris
Hello Team,
I have 3 SharePoint List.
1. List A
2. List B
3. List C
List C has lookup from List A and List B.
I using following formula but it's not working.
Patch(Problem,Defaults(Problem), {ServiceRequestLogId:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:selectedItem.ID, Value:selectedItem.Title}, ProductId:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",IdSmiley TongueroductDropdown.Selected.ID, ValueSmiley TongueroductDropdown.Selected.Title}})
Please guide.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
169 | |
94 | |
64 | |
64 | |
60 |
User | Count |
---|---|
241 | |
163 | |
95 | |
85 | |
82 |