cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PipManifold
Resolver I
Resolver I

Convert form selections to internally used acronyms (vlookup?) when adding responses to Excel table

Hi there

I’m wondering if it is possible to do the equivalent of a VLOOKUP in Flow when a response is submitted.

 

As part of a registration form, we want to know which campus and college a student is affiliated to, however, in our internal database we would like to have the acromymns rather than the full names the student selects from

These are our questions we asked the student which we would like to convert

Please select your campus:

  • Melbourne
  • Singapore

Please select you College:

  • Business and Law
  • Science, Engineering and Health
  • Arts and Humanities

I’ve created a table in the same Excel file which these form responses are to be recorded

Form term

Flow terminology

Melbourne

MELB

Singapore Institute of Management

SIM

Business and Law

BL

Science, Engineering and Health

SEH

Arts and Humanities

AH

 

Is there a Flow I can build where when a form is selected it does a ‘VLOOKUP’ and adds the flow terminology to the column in our registration database instead?

0 REPLIES 0

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,000)