Hello,
I need to implement the following requirement: I need to implement a combo box (cannot be dropdown as it needs to be searchable from the connected Sharepoint source, if I find a solution I need to add other combo boxes with the same approach but long folder list) that consists of the following text names found in my Sharepoint Document Library: Documents/IMS Published Folder:

Additionaly 04. OBSOLETE should not be included.
What seems to be most challenging is that this combo box needs to be dynamic. So if someone adds: 07. TEST this should be added to the combo box choices.
I have connected my Document Library named Documents to my Power App, but so far the suggestion I seem to be given is to attach a Power Automate with Sharepoint Send HTTP Request action to the ComboBox OnSelect. I prefer not to go this route as the flow could take some time to execute and I prefer my user to not wait for this.
Is there any other way to implement this requirement? Would love to hear your thoughts!
Best wishes,