Unanswered

Update 2 columns in a SP list from 1 field when submitting a new form

(0) Share

Report

Posted on by Hfow_

Hi,

I have a form with a "Summary" Field connected to a SP List, when submitting the form i want it to take the input from the summary field and essentially duplicate the value into another column in the SharePoint list, How would i approach this?

Any guidance would be greatly appreciated,

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @Hfow_, use the Patch Function after you Submit the Form:

SubmitForm(Form1);
Patch(
 YourSharePointList,
 LookUp(YourSharePointList, ID = Form1.LastSubmit.ID),
 {
 AnotherColumn: DataCardValue_Summary.Text
 }
)

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

Hfow_ 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @AhmedSalih, I've tried this - no issues/errors with the formula however the second column is still retuning a blank value, any idea on why this is the case?

Let me know know if you need any further information, appreciate the support!

Thanks

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Hfow_ try this:

SubmitForm(Form1); Patch( YourSharePointList, LookUp(YourSharePointList, ID = Form1.LastSubmit.ID), { AnotherColumn: Form1.LastSubmit.SummaryColumn } )

Was this reply helpful? Yes No
Hfow_ 4 on at

Like (0)

Report
Copy link

Link copied!

@AhmedSalih Still returning blank values unfortunately

Was this reply helpful? Yes No