cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Support
Community Support

Re: How to Map contact record of contact Entities in a different Entities which have relationship established

Hi @AmitSah ,

Yes, you can. I think the "Edit data in Excel" functionality could achieve your needs.

 

You could go to the Contacts Entity and Employee Details Entity in your CDS, then click "Edit data in Excel" button, then it would export your CDS Entity into a Excel table.

8.JPG

 

Opening the exported Excel file, then you could use the "Microsoft PowerApps Office Add-In" plugin to publish the data (including adding, removing, modifying, ....) from Excel file to your CDS Entity.

Please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-excel-addin

 

But if you want to bind the contact in your exported Employee Details Excel table, you still need to manually add the contact record in your exported Contact Excel table firstly, then publish the new contact record back to your CDS Entity. After that, you could click "Refresh" button though the "Microsoft PowerApps Office Add-In" plugin in your Employee Details Excel file, and select the LookUp field, then you could see these contact record you could reference there.

 

If above solution is helpful in your scenario, please go ahead to click "Accept as Solution" to identify my reply as helpful.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,748)