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 / Have powerapps treat a...
Power Apps
Answered

Have powerapps treat a single line of text sharepoint column as a choice

(1) ShareShare
ReportReport
Posted on by 179

Hey all,

I have a sharepoint list that is used in many places (powerbi, flows). It is a "single line of text" type column called "outcome"

I want this powerapp that I am currently working on to update the "outcome" column with "Pass/fail/pass with revisions". 

I have a form that uses the outcome as a data source and exists as a single datacardvalue type of "Text". I can change the format to "Number" for some strange reason, but I can't make it a dropdown it seems.

I first tried to change the sharepoint list from "single line of text" to a choice column with 3 options, but it completely broke all my flows and powerbi stuff I built off the sharepoint list. I don't want to have to manually go back and edit all my flows, powerapps, and powerbi stuff just to make this a choice column.

However, I don't want the users to manually type in "Pass" "Fail", etc. I want my data to be as unform as possible for reporting. 

Is there a way in powerapps I can limit this text column to appear to the end user as a simple dropdown with 3 choices? 

Any advice in this scenario is appreciated.

Thanks.

Categories:
I have the same question (0)
  • Verified answer
    poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    It sounds like the easiest for you is to keep the SharePoint column as a "single line of text" but restrict the user input to certain choices within your Power Apps Canvas App only.

     

    Here's a workaround you can try to implement:

    1. Create a Collection for the Choices: Use a collection to store the available choices, and then use this collection as the source for a dropdown control.

     

    ClearCollect(colOutcomeChoices, ["Pass", "Fail", "Pass with revisions"])

     

    2. Add a Dropdown Control: On your screen, insert a Dropdown control, and set its Items property to the collection you created.

     

    colOutcomeChoices

     

    3. Bind the Selected Value to the DataCard: You'll need to connect the selected value of the dropdown to the "outcome" field in your form. You can do this by setting the Default property of the DataCardValue to the selected value of the Dropdown after unlocking the form's data cards for editing.

     

    Dropdown1.Selected.Value

    You may also want to prevent this specific text field from being editable directly anymore, possibly using the DisplayMode property on the DataCardValue and using either DisplayMode.Disabled or DIsplayMode.View

     

     

    This way you can keep the SharePoint column as a "single line of text" but ensure that users can only select one of the pre-defined choices, achieving uniform data entry as you want.

     

    See if it helps @WBADAM03 

  • WBADAM03 Profile Picture
    179 on at

    Perfect! This is 100% what I wanted to do, it works. 

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard