Hi Power Apps community,
I have a off topic question about structuring data in my SharePoint list.
I want to know to best way to save "Other" option in my SharePoint list.
Lets say I have a SharePoint list with clients and another list for Invoice.
When I need to create an invoice, I need to select a client. I am saving only the client ID (from ID in Client SharePoint list) in my invoice SharePoint.
However, when I need to insert a client that do not exist, it is a bit of a problem because the client is not in my list and I cannot assign an id for this client.
I want to prevent redundancy in my SharePoint.
Does anyone know the best solution for this?
I have a form in Power Apps were users can select a customer from another SharePoint list with all my customers.
