Answered

Text input not patching to SP list (issue with patch formula)

(1) Share

Report

Posted on by KBeale

312

I am having trouble patching text to a column in a sharepoint list. My list is called 'Program Planning Test'. The column I want to patch to is a single line of text column called 'JE A1 Season.' The text field I want to patch is in a custom card (with othet text input fields). The control is called txtJEA1 and the Default property is set to LookUp('Program Planning Test', ID = varRecord.ID, 'JE A1 Season') (It is showing text that is already in the column).

I am trying to patch from a Submit button using the formula below (I am using the variable varRecord to show a record across forms).

Patch( 'Program Planning Test', ID = varRecord.ID, 'JE A1 Season', { 'JE A1 Season': txtJEA1.Text })

Can anyone advise me on how to update the formula (or anything else) so the text entered in txtJEA1 populates the column JE A1 Season when I submit the form?

Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (1)

Report
Hi @KBeale (again :)),

Try code similar to the following to update an existing record:

Patch('Program Planning Test', LookUp('Program Planning Test', ID = varRecord.ID), { 'JE A1 Season': txtJEA1.Text } );

Patch function reference: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
KBeale 312 on at

Like (1)

Report

Thank you! (Again!) And thank you also for the link... I clearly need to spend some time getting more familiar with the patch function 😉

Was this reply helpful? Yes No
KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report

My pleasure! We've all been there, practice makes perfect 🙂

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No