Helllo, we have built a Powerapp solution that consumes data from Dynamics such as Customer ID & Customer name and creates a folder for each customer as needed to store customer related data within Sharepoint, etc.
Due to the 5000 limit threshold within Sharepoint and the 20,000+ customers we are working with I don't have the option of creating a customer folder for all customers over time in the root of a document library. I am testing the idea of having a series of parent folders within the Doc library suchs as:
etc., So I am testing out how I could apply some logic within the powerapps to write to a field a default value such as A-E or F-J based upon the first character within the Customer. Basicallly, I am trying to acomplish if customer Burger King starts with B than default A-E into a powerapp field. If I can accomplish this I already have the rest taken care of on teh Sharepoint side, I simply need to capture this value upstream within the Powerapps. Obviously I would have to this for all ranges within the alphabet. If anyone has any ideas how to accomlish this I would appreciate it.