Hello.
Have two Sharepoint lists (DataList and TestFuelSkjema). I want to Patch Dropdown1 (Kunde) with registration button. Dropdown1 is connected to DataList, and I want to Petch to TestFuelSkjema (Kunde).
I do not get it with what I have tried.
I want to create a new record in TestFuelSkjema in Sharepoint.
Any suggestions?
Solved! Go to Solution.
What type of column is Kunde? If is is not a record based column (choice, Lookup, etc) then you will have an error.
If it is text, then you need to use the field from your selected dropdown.
Example, if your dropdown has a Kunde column in it, then your formula should have Dropdown1.Selected.Kunde
If the Dropdown is based on something else, then you need to look at the Items property to see what type of table columns it will have.
I hope this is helpful for you.
What error are you getting?
When you change the Items property to use Distinct, you are changing the names of the columns associated with that control. Distinct returns a table with a single column called Result.
So, if you reference that dropdown you would now be using dropdown.Selected.Result
Hi! @ENRM for patch you need an ID, look:
Patch(
CollItemsPres;{IdPres:DataTable_Presupuesto.Selected.IdPres};
{
ConceptoPres: Txt_Concepto_Pres.Text;
Lunes_Pres: Value(Txt_Lunes_Pres.Text);
}
)
And for dropdown should be: "Dropdown1.Selected.Value"
Hope it helped you
If this post answers your question, please mark my post as a solution!
If you like my post please click thumb up
What type of column is Kunde? If is is not a record based column (choice, Lookup, etc) then you will have an error.
If it is text, then you need to use the field from your selected dropdown.
Example, if your dropdown has a Kunde column in it, then your formula should have Dropdown1.Selected.Kunde
If the Dropdown is based on something else, then you need to look at the Items property to see what type of table columns it will have.
I hope this is helpful for you.
Kunde is simple line text in both forms in Sharepoint.
Found the problem. The title field was set to require value. Removed it and then it was sent to Sharepoint. But there is still a red cross over the button.
Yes, so as I mentioned - your Kunde is a text column. You are trying to assign a record to it. That is not valid and will give you an error. Selected is a record. It has columns in it (based on the Items property of the control). You need to use the formula I mentioned - Dropdown1.Selected.someColumn
Where someColumn is the column you want to put in Kunde.
@RandyHayes Yes, I did it the first time, forgot to mention it in the previous post.
Added a new button, and then everything was fine. Thank you.
Excellent!
Gets errors when I enter Distinct('Data Liste Fueling';Kunde) in #Items # for Kunde.
Any idea?
What error are you getting?
When you change the Items property to use Distinct, you are changing the names of the columns associated with that control. Distinct returns a table with a single column called Result.
So, if you reference that dropdown you would now be using dropdown.Selected.Result
Now I have learned a lot. Thank you. Result was the solution. Possibly I have more questions later😄