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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / File multiple forms on...
Power Apps
Answered

File multiple forms on select of dropdown

(0) ShareShare
ReportReport
Posted on by 29

I have connected my app to an Excel in SharePoint "Table 2"

 

I have a landing screen where I would like to select a candidate and populate my other 2 screens "Editform1" and "Editform2"

with related to the selected candidate. 

 

 

sel.PNG

can.PNG

pipe.PNG

I tried to set the "OnChanged" value of the drop-down, but can't seem to get it to work correctly.

Any help would be much appreciated.

 

Thanks, 

 

nm

Categories:
I have the same question (0)
  • Prabhakar_S Profile Picture
    735 Moderator on at

    Hi @nm2023 ,

     

    Please make sure you have a dropdown on your landing screen that displays the list of candidates. This dropdown will be used to select a candidate.

     

    Edit Form Binding:

    On the Editform1 and Editform2 screens, make sure they are connected to your SharePoint list "Table 2".

     

    OnSelect Property of the Dropdown:
    In the OnSelect property of your dropdown, you need to set the context for the edit forms. You should set the Default property of your edit forms to the selected item from the dropdown. This will load the data of the selected candidate into the edit forms.

    EditForm1.Default = Dropdown1.Selected;
    EditForm2.Default = Dropdown1.Selected;
    Navigate(EditScreen1);


    Clear Edit Forms:
    You should clear the forms when navigating to the landing screen or when a new candidate is selected. You can do this in the OnVisible property of your landing screen:

    ClearCollect(CandidCollection, { Dummy: "Value" });
    EditForm1.Default = CandidCollection;
    EditForm2.Default = CandidCollection;


    With these steps in place, when you select a candidate from the dropdown on the landing screen, it should populate Editform1 and Editform2 with the selected candidate's data.

     

    Thanks!!!

     
    If my response has been helpful in resolving your issue, I would suggest you consider clicking "Accept as solution" and "Give it a thumbs up" as a token of appreciation.
  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 2 on at

    Hi @nm2023 ,

     

    You don't need the OnChange property of the DropDown. 

     

    Instead, refer to the dropdown from the Item property of the forms:

     

    LookUp(
     Table2,
     CandidateID = Dropdown1.Selected.CandidateID
    )
  • nm2023 Profile Picture
    29 on at

    Hi @BCBuizer ,

     

    After I do the lookup and navigate to the form screen the form does not populate

  • nm2023 Profile Picture
    29 on at

    hi @Prabhakar_S ,

     

    When I try to set: 

    EditForm1.Default = Dropdown1.Selected;
    
    "Name isn't valid. Default isn't recongnized"

     

    I am getting the following error

  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 2 on at

    Hi @nm2023 ,

     

    Did you replace Dropdown1 with the actual name of the dropdown? In case you did, please share a screenshot that shows the evaluation of the formula in the formula bar (https://learn.microsoft.com/en-us/business-applications-release-notes/april19/microsoft-powerapps/view-results-formulas-subformulas-canvas-apps)

  • nm2023 Profile Picture
    29 on at

    nm2023_0-1692712783017.png

     

    It's returning the correct ID NM001, 

     

    but I am looking to populated the connected form with that candidates details. 

     

    but when I navigate, they form isn't been populated, I think they are been populated based on "ThisItem" property value

     

    Thanks, 

    NM

  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 2 on at

    Hi @nm2023 ,

     

    The formula seems to be working as it should. Did you use it for the Item property for the forms? Also, did you set Table2 as the for the DataSource property of the forms?

  • nm2023 Profile Picture
    29 on at

    hi @BCBuizer , 

     

    What do you mean by "Did you use it for the Item property for the forms"?

     

    I have set "Table 2" as the dataSource

     

    Thanks, 

    NM

  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 2 on at

    Hi @nm2023 ,

     

    Formulas are applied to properties of controls. In this case I was asking if you applied this formula to the Item property of the form, for instance:

     

    BCBuizer_0-1692715177395.png

     

  • nm2023 Profile Picture
    29 on at

    the "Item" is blank on the form I am trying to get populated from the dropdown: 

     

    nm2023_0-1692716099794.png

     

    I tried to add the lookup you provided, but it didn't work. 

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard