web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 0LHD3T6+fJb2FyM+Iot8YB
Power Apps - Building Power Apps
Answered

AutoFilled Fields Not Writing to SP List

Like (0) ShareShare
ReportReport
Posted on 4 Dec 2023 22:06:24 by 6

I have developed a form in PowerApps, based on an extensive, existing SharePoint List. There is a set of three fields, two of which autofill, based on the user's selection in the first field. (The goal was to ensure a 3-way match of the three fields...in other words, Field 1, called "Program" is a drop-down; there are corresponding entries for Field 2, called "LOB" and Field 3, called "State." Each combination of three is unique amongst the possible 18 options within the Field 1 dropdown.) For Field 1, Items reads, "Sort(Distinct('AHVM LOB Fields',Program),Value) and OnChange reads, "Set(ContactVAR,LookUp('AHVM LOB Fields',Program = DD_Program.Selected.Value)) NOTE: My data source for this piece is an Excel table called AVHM LOB Fields. The Default for Field 2 is ContactVar.LOB; the Default for Field 3 is ContactVar.State. When I create a new record, everything makes its way perfectly to the SharePoint list EXCEPT the contents of Fields 2 and 3. I am newer to PowerApps and have tried bits of all sorts of hopeful solutions to no avail. Any guidance would be very much appreciated!

I have the same question (0)
  • BamaGirl1443 Profile Picture
    6 on 04 Dec 2023 at 22:56:05
    Re: AutoFilled Fields Not Writing to SP List

    Hello and thank you for responding so quickly! I won't bore you with the lengthy description of the series of steps I took to arrive at my troubles, but your answer led me to the solution! I am super grateful!

  • Verified answer
    EddieE Profile Picture
    4,641 Moderator on 04 Dec 2023 at 22:35:52
    Re: AutoFilled Fields Not Writing to SP List

    @BamaGirl1443 

    Check that the Update property of the DataCards for the fields not getting submitted match the content that needs to go to SharePoint. Sounds like this is your issue

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete