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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patching a dropdown's ...
Power Apps
Answered

Patching a dropdown's selected value to excel

(0) ShareShare
ReportReport
Posted on by 35

So I am working on a form in which I need to add a dropdown for the person's name and then whatever they choose needs to then be patched to a column titled "name" in an excel "table1" I already have textboxes and checkboxes patched so the excel is connected but I cannot figure out the code to patch over the dropdown

Categories:
  • Mart302 Profile Picture
    65 on at

    Patch(
    Table1, 
    Defaults(Table1), 
    {
    Name: Dropdown1.Selected.Value 
    }
    )

  • ZacaryR Profile Picture
    35 on at

    It then just gives me the error message, "The type of this argument 'Name' does not match the expected type 'Text'. Found Type, 'Error'.

  • ZacaryR Profile Picture
    35 on at

    It also says Name isnt valid. 'Value' isnt recognized

  • Verified answer
    ZacaryR Profile Picture
    35 on at

    Figured it out, value needs to be the name of the column in the data table

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard