Unanswered

Using the Patch Function on Form Dropdowns and Form Dates

(0) Share

Report

Posted on by WillMurphy

I am trying to pull a Selected Value from a dropdown in a form, and use the patch function to send it to a SharePoint List. Here is my Code:

Patch('UR Rounds', Defaults('UR Rounds'), {Status:'Dropdown - EFS Filters'.Selected.Value, 'Title':DataCardValue8.Text, 'LastName':DataCardValue9.Text, 'Day/Night':DataCardValue10.Selected.Value, 'Date':DateValue2.Date})

DataCardValue10 is a drop down where the user selects either Days or Nights. DateValue2 is a date selector. The other items in this patch command work, including the dropdown labeled 'Dropdown - EFS Filters'.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

mmollet 3,187 on at

Like (0)

Report

Im not quite sure I understand what you are asking for. If you could clear that up a bit for me I'd be glad to try and help and im sure other would be as well. 🙂

Was this reply helpful? Yes No
WillMurphy 15 on at

Like (0)

Report

I got it figured out. Here is the correct code:

Patch('UR Rounds', Defaults('UR Rounds'), {Status:'Dropdown - EFS Filters'.Selected.Value, FirstName:DataCardValue8.Text, LastName:DataCardValue9.Text, Date:DateValue2.SelectedDate, 'Day or Night':DataCardValue10.Selected.Value, Location:{Value:"EnergeX Feed System"}, Task:{Value:"Filters Clean"}})

Thank you for the consideration!

Was this reply helpful? Yes No
Verified answer

WillMurphy 15 on at

Like (0)

Report

Essentially, My SharePoint list Column type was "Choice" and it needed to be "Single Line of Text"

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report

Yeah using complex columns in SP is a pain in the ass and I avoid it at all costs. I use number/int, text, and date columns almost exclusively. Glad you got it!

Was this reply helpful? Yes No