Map fields between 2 tables in model driven app

(0) Share

Report

Posted on by skvsp

223

Team,

Can you please advise how to map the column fields from one table to another table. (Order and Customer tables)

Ex: If i enter Order no and Description in the Order table form these info should get mapped and updated in the Customer table fields Customer No and Customer Desc.

Order No > Customer No

Description > Customer Desc

PFA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@skolisetti

You can use power automate to achieve the above , so you have a trigger on the first table which is order, and then create/update customer table accordingly.

Was this reply helpful? Yes No
skvsp 223 on at

Like (0)

Report
Copy link

Link copied!

Thanks Mira . Is it possible to do directly in the Dataverse itself without using Power Automate ?

The Order no and description will be entered by the user manually . Once he enters it should get updated automatically in the customer table fields .

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@skolisetti

No the way would be either power automate or plugin

Was this reply helpful? Yes No
skvsp 223 on at

Like (0)

Report
Copy link

Link copied!

Ok thank you

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@skolisetti

Let me know if you need any further help on this.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

Field mapping does appear to be unavailable through the Model Driven Power Platform/Dataverse UI- but the good news is however that you do not have to revert to plugins or power automate as the feature, like many, is still available only through the classic UI. Simply navigate to classic UI, open the entity relationship, then select mapping.

See official MS docs:
Map table columns in Power Apps - Power Apps | Microsoft Docs

Was this reply helpful? Yes No