Patch and the Left syntax

(1) Share

Report

Posted on by JasonM73

147

Hi all

I have a text label that displays the numeric value of a dropdown box via the use of the left command

$"K{Text(Left(Dropdown1.Selected.Value,1))}"

On my form I have a submit button that use the patch command to write the Dropdown1.Selected.Value to a column in a SP list - this all works, however I would like to take that numeric value and write to a separate column in the same SP list but stumbling on getting it to work

Patch(Test_POC,Defaults(Test_POC),{Title:InputProject.Text, 'Skill Level':Dropdown1.Selected.Value,Motive:Dropdown2.Selected.Value})

How do I add (Left(Dropdown1.Selected.Value,1) to the above please, lets call the column Number for example ?

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JasonM73,

Does the following work? Note: I've indented the code for readability.
Patch(Test_POC, Defaults(Test_POC), { Title:InputProject.Text, 'Skill Level':Dropdown1.Selected.Value, Motive:Dropdown2.Selected.Value, Number:Value(Left(Dropdown1.Selected.Value, 1)) } )
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
JasonM73 147 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you - all working as expected
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

My pleasure! Glad it's working, and thank you for the update.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.