Unanswered

'More' text appearing in Choices field on first form load

(1) Share

Report

Posted on by WillJay

101

I have a screen which loads a specific SP list item into a view or edit form. On the first load for this form the choices type fields always contain an additional 'More' concatenated onto the end of the value for that field.

Nothing fancy driving the field: Choices([@'Service Catalogue'].'System Type') as an example.

As soon as you leave and reload the screen with the form on it the 'More' disappears, this behavior is the same on the live form as well as in PowerApp Studio.

The only thing that really happens in that navigation is that the data source is refreshed, but the data source is refreshed on app start as well. I've tried forcing the refresh again prior to loading the form screen but behaves the same - it seems consistent to the first load of the form.

Any thoughts on what else to check?

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
Would you mind going a little bit more in to what the more is for? Like is it pulling www.powerusers.microsoft.com from sp list and adding like a description, or something, or is it say appending a partial web address to make it full. Assuming more was just a placeholder while you try to solve your problem. was just playing with one of my forms to see if your issue showed up in mine and it does not.

I put mine in the forms data card value slot, concatenated the value from sharepoint, added a 0 on to that, then converted it back into a value so it could post that data back into sharepoint. Initial use added 1 0 to end, then submitted that into sp, then I refreshed and number now had 2 extra 0's tacked on which means it definitely is keeping its concatenate function as intended.

Value(Concatenate(Text(Parent.Default),"0"))

let me know if it helped at all or more info on what happens on your side

Was this reply helpful? Yes No
WillJay 101 on at

Like (0)

Report
Copy link

Link copied!

Thanks for reply, I wasn't very clear about what I actually wanted it to do!

The field should just contain the value (which is being pulled from a sharepoint list) as you can see in the bottom screenshot. I have no idea where the 'More' is coming from, there's nothing configured on those list columns that would cause that. I can only assume it's related to the fact that they are all complex fields like choice or people.

All I need to do is reload the screen with the form and they all disappear, which is what I want. But I can't work out what it is that makes the 'More' appear in the first place...

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

Could you possibly open you sp list and share with us the exact settings of the column it is pulling from, and perhaps an example one complete item stored there so I can try to recreate it on my side to see what it is that is happening

Was this reply helpful? Yes No
WillJay 101 on at

Like (0)

Report
Copy link

Link copied!

Sure, they're all pretty standard choice or people fields with no real additional config on the list side. Here is the column settings for one of the example columns above:
And this is how the fields in the example above appear in the data source:
So I can only assume it's something in the Form config for opening a choice field in view mode. Perhaps something to do with using a single Form for view, edit and new modes depending on context...?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
I have recreated your list item format for the column exactly as yours is set up on a test sp list i have.
See below screenshots and also sample code. I am able to select an item name from a dropdown list, it is then populated into my edit form as intended, but without the more text. check that your code for the controls is similar to mine, otherwise not sure what's wrong because issue is not occurring for me it is also edit/view combined based on input of checkbox 😕

DefaultMode for form is
If(Checkbox1.Value=true,FormMode.Edit,FormMode.View)
Item is (testval is form dropdown selection below)
First(Filter(TESTPOWERAPPS,Title=testval.Title))

Text of my box that displays system type result is (using label, tried with this in default of a text input box and that worked same as well)
ThisItem.System_x0020_Type.Value

Onchange of my dropdown is
Set(testval,Dropdown1.SelectedText)

and checkbox, is just a plain old checkbox

Was this reply helpful? Yes No
WillJay 101 on at

Like (0)

Report
Copy link

Link copied!

Thanks, yeah I can only assume it's something to do with the first fetch of the data from the Sharepoint list when it's passed an ID on the screen load... Haven't been able to isolate it or re-create it outside of this specific solution!

Was this reply helpful? Yes No
MEF85 21 on at

Like (1)

Report
Copy link

Link copied!

Just wanting to add to this thread although it's a little old.

I am also getting this behaviour - specifically on two choice fields (SharePoint list is the data source) when trying to view a previously filled in form. It is a duplicated screen so the Edit is on one screen and the View is a different screen.

There is no sign of the 'more' on the SharePoint list either and on the Canvas app it's only two specific fields which are choices, it seems to be like a hyper link.

Was this reply helpful? Yes No
WillJay 101 on at

Like (0)

Report
Copy link

Link copied!

Weird, are the fields in a normal PowerApps form component? Do the 'more' disappear if you leave the screen and go back in?

I've still not found a fix for the issue, but we are building forms custom now using containers with our own controls and saving using patch(). So hoping to deprecate our last out-of-the-box forms, but would still be good to understand why this occurs!

Was this reply helpful? Yes No
WillJay 101 on at

Like (0)

Report
Copy link

Link copied!

Also @MEF85 - what is your form reading for the item? Are you saving the relevant Sharepoint item to a record variable in the app, or is the form looking it up directly?

Was this reply helpful? Yes No
MEF85 21 on at

Like (1)

Report
Copy link

Link copied!

Tempted to report it as a bug as it's pretty odd behaviour. If I click on the word 'More' it disappears or if I navigate back to my 'Home Screen' (which is a gallery of 'my requests' from the SharePoint list) then click to go back to that View Form screen it's gone.

Nothing special about the field at all, just a plain canvas app that I then added the data source to be a SharePoint list and just added the fields in I wanted to show.

As you say, it would be good to understand what is causing it if more than one person is getting it!

Was this reply helpful? Yes No