Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 4

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

  • Hfow_ Profile Picture
    Hfow_ 4 on at
    Re: Update 2 columns in a SP list from 1 field when submitting a new form

    @AhmedSalih Still returning blank values unfortunately

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Update 2 columns in a SP list from 1 field when submitting a new form

    @Hfow_ try this:

    SubmitForm(Form1);
    Patch(
     YourSharePointList,
     LookUp(YourSharePointList, ID = Form1.LastSubmit.ID),
     {
     AnotherColumn: Form1.LastSubmit.SummaryColumn
     }
    )
  • Hfow_ Profile Picture
    Hfow_ 4 on at
    Re: Update 2 columns in a SP list from 1 field when submitting a new form

    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

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Update 2 columns in a SP list from 1 field when submitting a new form

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard