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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Wrong data saving in t...
Power Apps
Unanswered

Wrong data saving in table - reference from one table to another in dropdown box

(0) ShareShare
ReportReport
Posted on by 158

Hello,

 

I have two tables in dataverse: 'CORR infos': with information, 'CORR db': with records. In 2nd table I need a column with a choice of all part numbers from column in 1st table.  I have created a form in canvas app to add records to my 2nd dataverse table and I can see a dropdown list with all my parts to be chosen. My patch function seem to be working fine as well but when I look at table after saving I can see only this bit: 'CORR' while it should be a part number starting with 'E50-...'.

 

DataCardValue3 -> Items -> 'CORR infos'.Part

 

marcy_pi_0-1674204896335.png

 

Bit with code for 'Part' column: 

marcy_pi_1-1674204976610.png

 

This is what I can see in table after saving: 

marcy_pi_2-1674205316614.png

 

 

I have tried many options but non of them were actually working... the column in 'CORR infos is Text format while in my second table the 'Part' column is Lookup format. 

 

I also have a label on side which should show me other info from 'CORR infos' as reference and it's showing me data which I want:

LookUp('CORR infos', Part=DataCardValue3.Selected.Part, Setup_Comment)

 

Can anyone help with this one, please? 

 

Regards 

 

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard