Power Platform Community Forum Thread Details

I have two Screen and on First Screen have 2 Editform of Account Tables

Second Screen, I have 1 Contact table editform having Account Table Lookup and item =[Choices([@'Contacts'].account)

On First Screen , If user only fill 1 editform of Account Table Name for example DataCardValue1 have value then in second screen Account Lookup have default value DataCardValue1.Text

If user fill both edirform of Account table then in Second Screen Account Lookup show DataCardValue1 and DataCardValue2 as choices

Categories:

Building Power Apps

Hi @Anonymous1198 ,

Could you please share more details about your scenario? What are the Mode properties of the two Forms? Based on your description, I suppose they are both New forms, so, after the submission of the two forms, there will be two new accounts in the Accounts table, and also be the choices in account LookUp column. To achieve your need, you can save the account names in a collection, apply below formula in OnSuccess of the two forms:

Collect(colAccount, EditForm1.LastSubmit)

Collect(colAccount, EditForm2.LastSubmit)

OnVisible of screen1, need to clear the collection so the collection will only include new added account names:

Clear(colAccount)

On Screen2 Account DataCardValue, which is a Combo box, set DefaultSelectedItems property as follows:

colAccount

The reason is, Dataverse LookUp column will include all the entries of the main table as selections, to make the two new entries as default values in the Combo box, you can directly use the new submitted records.

Best regards,