Verifying answers with external tables (excel)

[jeiffel33]

Hi everyone,
I'd like to verify answers entered in a form through external tables (in Excel, for instance).

Here is the situation
I run a competition and need to create two forms for the registration of
- teams
- members of each team (already registered)

The field linking both tables is the "team's name"

For the "Team's Members" form, I want to make sure the Team has already been created => I therefore need to test the "Team's name" entry :
- if the entry exists in the "Teams" database (Excel file linked to the Form, I guess) => the user will be allowed to enter the data for a new member
- if it doesn't exists, then the user will NOT be allowed to carry on (with a message indicating he has to create first a "Team"

Any idea on how to do this ?
Thank you in advance

[#2]

@jeiffel33 Microsoft Forms cannot connect to any data while the form is open so, you can't check if a team name exists before the user submits the form.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

[#3]

@Rob_Elliott 

too bad... but thanks for your fast answer !