forms- DS as Sharepoint Lists

[faisalmirji123]

Hello, I have a list of Students For Each Student There is data to be filled in the Form 

For Each Student Name there Should be 1 form for data to be filled  and 2 Display Modes i.e., On First Submit Form Display Mode of the form Should be New, Else Display mode of the form should be Edit... plz give me your ideas on how to do it....

[BCBuizer · Accepted solution]

Hi @faisalmirji123 ,

In the OnVisible property of the screen that has your form, you can set below

If(IsEmpty(LookUp(YourSharepointList,Student.Email = User().Mail),NewForm(YourForm),EditForm(YourForm))

Basically it checks if the current user already has a record in the Sharepoint list and sets the FormMode accordingly.

[faisalmirji123]

Hey!! Thanks for The Suggestion It Worked For me..