Room Configurator hardware list using Forms & Excel

The only way to do this is with a flow in Power Automate although I would always use a SharePoint list instead of Excel which is not a good data source.

Depending on how many meeting rooms you have you would probably use a switch control for each one and get the details of the items from the list,  then conditions inside each switch case for the other answers. Depending on the response you would add the item details and costs to variables. Finally you could send an email with the text and the cost.

So you need to start investigating Power Automate. If you've not used it before there are very good videos on YouTube by Shane Young and Reza Dorrani.

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