Use Field List To Add Remove Or Arrange. You can use column formatting to create buttons that when selected run Flows on the corresponding list item. If the field is set for automatic sort please right click any cell in your pivot table and choose Refresh and then the field will be sorted with your custom lists order.
Say I have a list called listOfFruits in my main form. You can use the same list for multiple drop-down lists. It appears when you click anywhere in the PivotTable.
Go to the Lists menu and select Item List.
The Flow Launch Panel will be displayed after choosing the button and the Flow will just run. You can also use macros to remove pivot fields -- Remove Pivot Fields with Macros. How to Hide WorksheetsTabs and Entire Workbooks in Excel. Choose List in the Allow field.
