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 / Fetching Values from T...
Power Apps
Answered

Fetching Values from Text to Dropdown

(0) ShareShare
ReportReport
Posted on by 2

Hello Everyone,

 

I have an App which is linked to a SP List (which is having all Text Columns). I wanted to have cascading dropdown options hence i created another list with the Status1 and Status2 columns. Now on top of the text fields data cards (from the original list) I have added dropdowns (linked to the another list) and selecting the values from it. This is working fine. But i want that when i open the form in edit mode again, the dropdown should show the values which are entered earlier in to the backend text columns of the original list. Can anyone please help on how to do this?

 

Thanks in advance!

 

Regards,

Akshay  

Categories:
I have the same question (0)
  • LuizVicente Profile Picture
    984 Super User 2024 Season 1 on at

    Does this help you?

     

    // Put this code in the Items property of the dropdown.
    If(
     MyForm.Mode = FormMode.Edit, 
     OriginalList.Column, 
     AnotherSource.Column
    )

     

    If not, share some images of your app, etc...

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @AkshayManke 

    Turning a Text column into a dropdown is one of the easier actions to do in PowerApps forms because they have built in this ability for you.  When you use it, it will automatically do all the connection and displaying and re-displaying without you having to do a thing.

     

    To do so, when you add your Text field to your form (and you have to do this before you unlock the datacard - if you've already unlocked it, then delete the field from your form and add it back), you can then choose the Control Type and change it to "Allowed Values".

    This will create a new property on your DataCard called AllowedValues.  NOW, unlock the datacard so you can edit that.

    There, you can put in the formula to pull from your Status lists.

    The only caveat (to keep it simple) is to provide the AllowedValues property with a table with a single column called Value.

    So, if you want, for example, all the Titles of a list to show in your dropdown, then set the AllowedValues property to:   RenameColumns(yourList.Title, "Title", "Value")

    If you need to incorporate a Filter, then:

    RenameColumns(Filter(yourList, filterCriteriaHere).Title, "Title", "Value")

     

    After that, everything else is done for you.  It will show prior values and it will also convert the dropdown to text for submitting the form.

     

    I hope this is helpful for you.

  • AkshayManke Profile Picture
    2 on at

    Many Thanks @LuizVicente and @RandyHayes, for helping me on this. The solution i got from the suggestion given by @RandyHayes, but thanks for your help too @LuizVicente.

     

    Warm Regards,

    Akshay

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard