Note: To implement the following scenario you need to have Scaffolding and Reporting.
Create two pages Dynamic Page, Reporting Page.
In Dynamic Page add repeating data macro and inside repeating data add Text Data and number data:
Now save the page and click on Edit contents, then enter the desired options in New option parameter and input desired order number in sort value:
Click Save
In Reporting Page add a list data macro, inside list data add a report block.
In report block add two macro, Local reporter and Report body.
Input data:<repeating table name> and SpaceKey:PageName in Local Reporter key and source parameter.
Inside Report body, create a list option and inject %data:<text data name>% and %data:<number data name>% in value and sortvalue parameter:
Click on Save.
Now go to Dynamic Page and add options.
Come back to Reporting Page and you will see options are updated dynamically.