
Announcements
Hi peeps !
I'm seeking for your help regarding the above matter.
I have 2 two forms in different screen with different datasource but have lookup column and i am using SharePoint List for datasource
Student List :-
| Column Name | Data type |
| Student Name | Text |
| Passport | Number |
| Birthdate | Date |
Release of Child
| Column Name | Datatype |
| Student | Lookup (Student List, Student Name) |
| Individual Name | Text |
| Vehicle Registered No | Text |
Form 1 in Screen 1 :-
Allow user to fill in information of the kid and submit as registered student
Form 2 in Screen 2 :-
Allow user to register person that can pickup the student, for the lookup column, it gives me combobox.
My Goals :-
1. To have auto defaultselecteditems for student in form 2 as of submitted in previous form.
Problems:-
1. On Student Field in Form 2 at Screen 2 , it appear the name as the previous screen. But it did not capture the value when i submit the Form 2 , it turns our blank.
Thanksss
Hi @Anne98 ,
Based on your description, we reproduce your problem.
You need to change formula like this.
SubmitForm(Form1);
Refresh('0705_2');
Navigate(Screen2,ScreenTransition.None,{StudentRef:Form1.LastSubmit.ID});
ResetForm(Form1)
Form2:
DefaultSelectedItems:
LookUp(Choices([@'0705_2'].Student), StudentRef = Id , ThisRecord)
Items:
Choices([@'0705_2'].Student)
The Button to Submit Form:
SubmitForm(Form2)
;ResetForm(Form2)
Hope this will help you.
Best Regards,
Tina