Power Platform Community Forum Thread Details

So i have a microsoft form we are having customers fill out. I have learned how to set up a power automate flow to have it populate in a teams list (sharepoint list)

In the teams/sharepoint list, not all of the customer information will be fill in from the form.

Id like where when a new submission happens, there is some sort of formula or something that reads specific answers (like their zip code or specific choices they chose from a drop down) and have those answers trigger and auto populate other blank columns

Example: customer enters zipcode in the microsoft forms and when sharepoint recieves that, it will auto populate in the salesman section the salesman from their local area and that salesmans supervisor.