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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Fetching Values from T...
Power Apps
Unanswered

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,297 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard