183
I have two different forms within the same app that a user can use to make submissions. Both write to the same list, but with different information for the host organization they are supporting.
I am collecting their unique employee ID # on both forms, and thought I could somehow use that to cross reference if they have submitted to either Org A or Org B.
I only want users to be able to submit once for each organization, but two times total if they choose to submit to both.
Hello @NathanFra
You can do this in various ways but one quick one I can think of is adding an Org and Email column in your SharePoint list.
Then on your app's OnStart property Screen or your Screen's OnVisible property to check if there exists a record already on SharePoint. The code maybe something like this:
Share
Report
All responses (
Answers (
Set(hasOrgARecord,IsBlank(LookUp('Your_List_Name',Email=User().Email, Org="Org A"));
Set(hasOrgBRecord,IsBlank(LookUp('Your_List_Name',Email=User().Email, Org="Org A"));
You can then use the variables hasOrgBRecord or hasOrgARecord to either
