Hello,
If a user creates a record in the vehicle parts table, then a column Spare Tires from the 'Checks' entity needs to be auto-populated with a column 'Spare Wheel' in the vehicle parts table'. Existing 'Spare tire' field is a dropdown; therefore, where there is no information recorded within the vehicle parts for a 'Spare Wheel', this should be kept as a dropdown field with the same options present. Otherwise, it should display the value in single-line text.
Is it possible to change a choice data type to single-line text in a form as per the above scenario? If yes, can anyone provide me with the steps to do it?
Thank you for your assistance!
No, those are 2 different tables.
When you say "entity", are you talking about different SharePoint lists? So are Vehicle Parts and Checks two separate SharePoint lists?
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473