Structure SharePoint list with PowerApps

[JB0007]

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. 

[Nogueira1306]

I would say that you should allow your users to create clients and ifthe client does not exist, you send them there. You can always allow the user to write custom values but that can caus redundacy because someone can write:

Customer 1

and other can write

customer1

and they are the same customer...

To prevent that you can LOWER or UPPER everything..

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

[JB0007]

Hi @Nogueira1306 , thank you for your feedback.

I was thinking the same thing. However, in my company only 1 person is responsible for creating clients in order to prevent entering the name of the client wrong. However, if that person is busy, it would stagnate the work of the person creating the invoice. 

[Nogueira1306 · Accepted solution]

You can always allow them to create the client as a provisory way and the responsible to create the customer has to approve the customer later... If she does not approve it, you must delete all the invoices + customer. If she approves, no problem...

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!