Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Item 1, Item 2, Item 3.... Showing as values for NewForm control

(0) ShareShare
ReportReport
Posted on by 574

This should be an easy one - I have a NewForm control that DataSources to a SharePoint list - problem is the choice column values are showing as item 1, Item 2, item 3 ..... not the real choices that in the column. Anyone ever seen this before and knows the fix? Thx in advance.

Categories:
  • animta Profile Picture
    animta 9 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    I found a fix for this. You have to add single quotes to the column name.

    Ex. Choices([@'Requisition Request Form'].'PostInternal_x003f_') The name inside the single quotes should be your column name from your SPO list.

     

    animta_0-1720743927280.png

     

  • rernst Profile Picture
    rernst 4 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    I found a strange workaround; while editing form, click Fields...Edit on that DataCard properties (see image).  Change the layout to "Double", select all the text/search field dropdown values, then change back to Single, save, publish and voila, I get my choice values rather than Item 1, Item 2, etc. I had three other columns with this issue, and this fixed each one!

    rernst_0-1720020329565.png

     

  • Jason-E Profile Picture
    Jason-E 35 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    Having the same problem. I have even created new columns and added them, and am having the same problem. But the columns I created last week and added this morning are working fine - and when in edit mode, display the SharePoint list options.   

    This is extremely frustrating because I really don't know where to go from here.

  • Samuel Rollón Profile Picture
    Samuel Rollón 122 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    I have also the same problem.

     

    My solution is delete the card and add it again. Also, if that doesn't works, I unlock the DataCardValue, delete it and add it again.

     

    I hope it helps!

  • CM24 Profile Picture
    CM24 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    I've just had this issue - did anyone ever resolve it?

  • ctedesco3307 Profile Picture
    ctedesco3307 574 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    @Anonymous - that's all I got my friend - I'm sorry. I do remember actually having to remove and retype in the field name, even in some cases I had where the column name and field name were the same. I know it sounds lame.... but delete Department, re-type it in, re-save, see if that does anything. PowerApps is just glitchy sometimes. 

  • Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    Thanks @ctedesco3307 However, it is not the case for me. I actually deleted the list I initially was using (which had different display name and field name). I still facing the same issue with new List as well. Please see below screenshots. I actually copied / cloned an existing app and changed the data source and forms. Not sure, if that is a problem. I recreated the list and readded the Powerapps form, with no luck.

     

    PowerApps: Datacard - Items settings

    Athamoth_0-1661846213794.png

    URL of the FIeld

    Athamoth_1-1661846268786.png

     

    PowerApps - Preview

    Athamoth_2-1661846304829.png

     

     

  • Verified answer
    ctedesco3307 Profile Picture
    ctedesco3307 574 on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    @Anonymous  I actually did get a solution - Go to the data card in the form that is showing item... Select the Items property for that data card and make sure the system field name, not the column name is set. My column names are different then my system field names in my SharePoint and the items property automatically defaulted to the column name. Once I changed it - worked perfect. You can see the system file name if you sort by that column in the URl or go into list settings - look at the url. 

    ctedesco3307_0-1661794350438.png

     

  • Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    I am facing the same issue, does anyone found a solution for this? Actually this may not be an PowerApps issue, as I am not able to save the form in SharePoint (NewForm) as well.

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Item 1, Item 2, Item 3.... Showing as values for NewForm control

    The default property of the card should be ThisItem.CR_TYPE 

    The Items property of the combobox inside the card should be Choices('PS Contract Totals'.CR_TYPE).Value

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard