web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Suggested answer

How to populate a cell in a dataverse table based on data in another cell?

(0) ShareShare
ReportReport
Posted on by 11

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!!

I have the same question (0)
  • Suggested answer
    KeithAtherton Profile Picture
    3,690 Most Valuable Professional on at
    How to populate a cell in a dataverse table based on data in another cell?
    Hey. Look into classic workflows, they may do what you need:
     
  • Milosh Profile Picture
    48 on at
    How to populate a cell in a dataverse table based on data in another cell?
    Hi @Schnauzerl,

    There are two options in Dataverse. In your "Cust. table" define City column as :
    1. Calculated field or
    2. Formula Field with Power FX formula "ZIP Code".'City'

    Regards,
    Milosh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 766 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard

Featured topics