Check Forms Data in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2659761%22%20slang%3D%22en-US%22%3ECheck%20Forms%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659761%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20design%20a%20platform%20through%20Forms%20to%20request%20getting%20new%20card%20in%20my%20organization.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20an%20excel%20contain%20people%20who%20attend%20the%20courses%20so%20they%20are%20only%20allowed%20to%20have%20the%20card.%3C%2FP%3E%3CP%3ESo%2C%20when%20making%20a%20new%20request%2C%20system%20should%20check%20the%20excel%20data%2C%20if%20the%20person%20is%20there%2C%20then%20approve%20his%20request.%20Otherwise%2C%20reject%20him.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20guideline%20on%20how%20to%20make%20this%20system%20using%20Forms%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2659761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660218%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20Forms%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131182%22%20target%3D%22_blank%22%3E%40Aaisha355%3C%2FA%3E%26nbsp%3Byou%20can't%20do%20this%20with%20Forms%20on%20its%20own%20as%20it%20has%20no%20functionality%20to%20check%20anything%20in%20Excel%20or%20anywhere%20else.%20But%20you%20can%20use%20a%20flow%20in%20Power%20Automate%20to%20grab%20the%20response%20and%20look%20up%20whether%20the%20user's%20email%20address%20is%20in%20your%20Excel%20table.%20If%20it%20is%20approve%20the%20request%2C%20otherwise%20reject%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello

 

I design a platform through Forms to request getting new card in my organization. 

I also have an excel contain people who attend the courses so they are only allowed to have the card.

So, when making a new request, system should check the excel data, if the person is there, then approve his request. Otherwise, reject him. 

 

Any guideline on how to make this system using Forms? 

 

1 Reply

@Aaisha355 you can't do this with Forms on its own as it has no functionality to check anything in Excel or anywhere else. But you can use a flow in Power Automate to grab the response and look up whether the user's email address is in your Excel table. If it is approve the request, otherwise reject it.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User