Skip to main content

Notifications

Power Apps - Building 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:

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard