I was following this to pull Additional Fields to appear on the form using calculated field and it is worked perfectly. However, when I try changing the calculated field to text box, it won’t load in the SharePoint list when click New or clicking on the item. It worked in the preview tho.
For example, in my case, my list A has a People & Group field and a Department (text box) field, and my list B is “Staff List” with name of staffs, departments, titles, etc. So when I choose People & Group, it should match the DisplayName in People & Group with the name in list B with department.
What am I missing?