Patch to Sharepoint

[ENRM]

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?

[ricardox180]

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

[RandyHayes · Accepted solution]

@ENRM 

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.

[ENRM]

@RandyHayes 

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.

[RandyHayes]

@ENRM 

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.

[ENRM]

@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.

[RandyHayes]

@ENRM 

Excellent!

[ENRM]

@RandyHayes 

Gets errors when I enter Distinct('Data Liste Fueling';Kunde) in #Items # for Kunde.
Any idea?

[RandyHayes · Accepted solution]

@ENRM 

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

[ENRM]

@RandyHayes 

Now I have learned a lot. Thank you. Result was the solution. Possibly I have more questions later😄