Hello,
I created a table that contains all zip codes, Cities, ZIP Code Regions and Geo Location Data. ("ZIP table")
Now I want to automatically populate the city name in the City Column of another table ("Cust. table"), once the ZIP Code has been selected in ZIP code column of "Cust. table".
The Zip Code Column of "Cust. Table" ist connected (N:1) to the Zip Code Column of "ZIP table" as a search.
Is that possible without using creating a Power App? (Since the data will also come in via MS Forms or an API Webhook)
I really hope my request was clear an concise.
Any help is highly appreciated!!