Power Platform Community Forum Thread Details

Hello,

I am looking to create an intake form to track attendance at a conference, where the potential attendees are contained in a SharePoint list and/or Excel spreadsheet. I would like the user to be able to pull the following information from the SharePoint list/Excel spreadsheet for each attendee upon entrance:

- Event Name (from list of events);

- Date (to be entered manually);

- Once Event Name and Date are Selected, I would like the user to be able to input multiple attendees with the following information for each event/date;

- Company Name to be selected from a list of options (each company has a handful of potential attendees associated with it);

- Attendee, selected from a list of attendees driven by the Company selected above (once you select the Company, a handful of Company representatives will show as options);

- Repeat selection of Company and Attendee, in the 2 preceding steps until all attendees for that date have been entered.

When the user is finished entering the attendees for a given event and date, as detailed above, the user would "submit" the data and transfer it to another list/worksheet with these columns of data: EVENT NAME, DATE, COMPANY, ATTENDEE.

This process would be repeated for each day of the Event with the data being added to the list/spreadsheet of attendees. I'd love for this functionality to be available in a mobile app.

Thanks in advance!

Categories:

General Questions