After a bit of a struggle, I have been able to connect 2 Sharepoint source lists to a "live" SharePoint, incremental list that grows as data is added.
However, I am losing the will to live as understanding (in plain english) how to update the live list from the selected drop downs. I have used this formula and have seen similar formulas and have the top part seemingly populating correctly.
If you take it as 3 parts, what are the 2nd two parts doing ? In my mind (in plain speak), we are tyring to send a valu.e from the Drop down to a "receiving" value in the incremental list....
Ok, so taking 1 & 2 what is the relevance of Id: in 1? Is it a label or what?
What is binding what to what? I also seem to have disspearing "update" field in the datacard so had just been writing in the title?
Can anyone just explain what 1 & 2 are doing? i.e is it binding at ID level? Is the code at datacard level and so on?
Grateful for any advice...
If ddActionOwner is a control using a SP complex field type then I think you can get by with a simpler formula in your screenshot. Try using just "ddActionOwner.Selected"
Jeff Hi - Does that then "write" and update the value into the incremental SharePoint list?
DDActionOwner is a "name" selected from a defined cascading list, which all works.....but this is actually to say, Ok, I went through cascacading menus/drop downs, but now I want to use that final value and save it.....
Id - relates to the internal ID column in SharePoint
and Value is the text value associated with the reference to the lookup column
You could also use
LookUp( Choices(DataSource.LookupColumnName), ID= DDActionOwner.Selected.ID )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This is all I am trying to do - So are we saying that Id (as per example off the web) is the [ID] field . Is this needed every time? I dont understand the breakdown of the code for the formula. If I understand it, that will help my understanding of where any errors lie etc.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!