Announcements
Working a form that links to SharePoint and I would like the form to be the same order as SharePoint. Problem is, depending on the ticket type, the order changes.
is there a way I can designate the sort order like I can with a gallery from a collection?
Hi @Castner ,
A Form has only one record - what Order are you referring to?
@WarrenBelz I have a form that depending on the type of ticket it is, certain a fields in the form are in different order (or not there but that is easy to solve).
what I have been trying to do is something similar to below
‘If(dropdown1.Selected.Value=“Option1”(Sort(field1,field2,field3)’
if another option is selected that order changes.
@Castner ,
Are your referring to a Form or a Gallery? If a Gallery (I suspect this is the case) - the Items
Sort( YourDataSourceName, Switch( dropdown1.Selected.Value, “Option1”, field1 “Option2”, field2 “Option3”, field3 ) )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
This is a form. But the function is available in gallery so been trying to figure out if it’s possible in the form view as well but can’t get it to work.
Sorry @Castner , but I am a bit lost here. A Form only displays one record, so Sort is is irrelevant - what exactly are you trying to do?
@WarrenBelz In FormMode.New
i want when when someone is creating a new SharePoint ticket they have an option from three different ticket types. Depending on the ticket type chosen the input fields rearrange. For example
ticket type 1:
input field 1
inout field 3
input field 2
ticket type 2:
input field 3
Ticket type 3:
i have a drop down that users can select the type of ticket to be created but can’t figure out how to change the order of the input fields of the form.
In the form or the drop-down?
If the Form, you will need three forms.
@WarrenBelz The form and I was afraid I would need 3 different forms. Guess I’m gonna have to figure out how to wire up everything or bite the bullet and they’ll just have to deal with the input fields not matching up with SharePoint till that function is available. I wasn’t sure if I could use the Item field on the form to manually rearrange the fields.
You can play with the Visible of cards conditionally, so you may be able to have some different combinations. If you consider this, I would advise using Patch or UpdateIf instead of SubmitForm, however this would be more work and bother than simply doing three forms on the one screen and setting the Visible on the one you need.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1
