Answered

how to write data to different table than lookup values?

(0) Share

Report

Posted on by galos

256

I am using a form to write information on Table 1 and am using combo boxes that will pull lookup values from Table 2, but each time I submit the form, it does not write the data to Table 1. How can one pull lookup info for combo boxes from one table, but write the data to Table 1?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Crys.Dom 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show that your code in your form (items) of your table 1 and in your combo box (item) of your table 2?

Was this reply helpful? Yes No
galos 256 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CrysDom - for more details, you can see this post: Re: How to pull data from one table but push updat... - Power Platform Community (microsoft.com)

I did not get any replies, so I assumed it might not be possible. Trying to simplify the question to find out if it's possible.

Was this reply helpful? Yes No
Crys.Dom 62 on at

Like
a
(0)

Report
Copy link

Link copied!

usea a lookup column type in your table 2, creating a relationship between your table 1 and your table 2. In this way it will be easier to obtain the data from your table 1 and create it in the form of your table 2.
table 2
column Director --- type lookup
Column Manager --- type lookup
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
galos 256 on at

Like
a
(0)

Report
Copy link

Link copied!

are you saying I should use a lookup in the SP List or a lookup in the Form in Power Apps?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @galos,

Could you please tell me that what is the column type of the Director and VP, both Text column?

Show me how you set the update property of the data card corresponding to the VP and Director?

What's more, if you populate the Manager ComboBox with the items from Table1, I think this is the key to your issue.

Here is a simple demo for your reference, I populate the ComboBox with another field from another list, here is how I set the Items property and DefaultSelectedItems property of the ComboBox:

1). Items property:

Distinct(Table1,Manager)

2). DefaultSelectedItems property:

[ThisItem.Manager]

3). Set the Items property and the DefaultSelectedItems of the ComboBox corresponding to Director as below:

Filter(Table1,Manager=ComboBox10.Selected.Result).Director

DefaultSelectedItems of the ComboBox corresponding to Director as below:

[ThisItem.Director]

Was this reply helpful? Yes No