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.
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.
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!
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.
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!
I've just had this issue - did anyone ever resolve it?
@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.
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
URL of the FIeld
PowerApps - Preview
@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.
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.
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