I have been given great advice regarding using SharePoint Lists as a data source in Power apps. Our lists should only include text (Single line of text & Multiple lines of text), numbers, and Dates where you need them.
My question is regarding field types "Yes/No" and "Choice". We use multiple lists for each Form and many of our lists are updated by staff, not by us. So, they are responsible for entering some of the data that the Forms use. For example... If we had a SharePoint List of Cities, then we would have one staff member who would edit the SharePoint List to add cities. We also have a field that says whether the city is active or not and the values in the field would be "Yes" or "No". We use that so that, in the Form, we would only load the cities where the Active field is set to "Yes". The problem is that if we don't use a field type of "Yes/No" or "Choice", we would need to validate what the staff member is entering, just to make sure they don't enter "Yea" instead of "Yes". Does it make sense, in this case, to use a field type of "Yes/No" or "Choice" in our SharePoint List or is there a better way of handling so that we keep with best practices of using only text, numbers and possibly Dates?
