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 Apps
Unanswered

Column saving

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

HI!

I gotta problem, Im wondering if I have one column in powerapps and sharepoint which is a choice, can I save it's value to another one which is a text format?

Categories:
  • RusselThomas Profile Picture
    4,014 on at

    Hi Alban,

     

    I don't see a problem with what you're suggesting - I'd say you just get the value from the one column and save it back to another?  Do you have more details on your specific example I can help you with?

     

     

    If you're using an Edit Form and you have both columns in the same source (the choice column and the text column), then unlock the text column input control and set its Default property to the DropdownControl.Selected.value of the choice column's dropdown control.

     

    Text column default set to option column valueText column default set to option column value

     Hope this helps,

     

    RT

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    There's my problem, mostly it says that there caanot be a record value where it suppouse to be a record one.

    2018-07-03 09_51_23-.png
    2018-07-03 09_51_38-.png
    2018-07-03 09_51_26-.png
  • RusselThomas Profile Picture
    4,014 on at

    Hi there,


    What is the dropdown column? 

     

    If it's a simple list of options ["yes", "no", "maybe"] represented by a dropdown control, then DropDown.Selected.Value should work.  If it's something else, (like a people picker) you may need to navigate the control slightly differently.

     

    What the error is telling you is that the Value you've selected is actually a Row of data, not a single field - you need to drop down a level to get the field.

     

    Kind regards,


    RT

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This worked for me "DataCardValue1.Selected.Vendor"
    Where first is the place I get data from, and Vendor is the name of a whole card field. 
    So it works but I have no idea why 😛

     

    2018-07-03 10_17_22-NVIDIA GeForce Overlay.png
  • RusselThomas Profile Picture
    4,014 on at

    Glad to hear it 🙂

     

    Basically, if the dropdown Items property points at a Table, (as opposed to an Array of options) then beneath that you woud be able to select which column of the table to display in the dropdown options eg: Value = Vendor. 

    This would then provide a dropdown of all the values in the Vendor column for that Table.

     

    When a selection is made, the Selected.Value of the selection is the entire row of data that the field you selected belongs to. 

    Specifying a specific column will return the data for that field in the selection - hence Selected.Vendor returns the value for the vendor column in the row that was selected.

     

     

    Kind regards,


    RT

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    Could you please share a bit more about your app's configuration?

    Do you want to display value from the Drop down control within a TextInput control?

     

    I don't agree with @RusselThomas's thought almost. I assume that the Items property of the Drop down control is set to a Table (Just like an Array with many options) as below:

    Table(
    {Id:1,ProductName:"Product1",Vendor:"Apple"},
    {Id:2,ProductName:"Product2",Vendor:"Amazon"} )

    Then you could specify which column (of above table) as the display value within the Drop down control via specifying value within Value property as below:Test1.gif

     

     

    The DataCardValue1.Selected.Value formula would retrieve the display value that you selected from the Drop down control. e.g. You select Apple from the Drop down control, the DataCardValue1.Selected.Value formula would retrieve the following data:

    Apple

     

     

    The DataCardValue1.Selected formula would retrieve the entire row (from the above table) where your selectd value (from the Drop down control) belongs to. e.g. You select Amazon from the Drop down control, the DataCardValue1.Selected formula would retrieve the following data (one record):

    {Id:2,ProductName:"Product2",Vendor:"Amazon"}

     

    Please check if the field (or column) that you displayed within the Drop down control is a Text column or a Record column (e.g. Person or Group type column in SP list, Choice type column in SP list.etc)

     

    More details about the Drop down control within PowerApps, please check the following article:

    Drop down control

     

    Best regards,

    Kris

  • RusselThomas Profile Picture
    4,014 on at

    Good point Xida, I just assumed Value to be a record, are you saying it's more likely the currently selected text value as opposed to the whole record then?

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 339 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 289

#3
Mohsin Ali Profile Picture

Mohsin Ali 228

Last 30 days Overall leaderboard