Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Creatiing an On Demand Load button to load data from Sharepoint


I have created a sheet that allows another department to generate a quote and save that data to a sharepoint list. I am trying to create a way for them to retrieve the data from the List.  Initially I created a Drop Down Menu (ExistingQuote) that looked at the list and filtered by the username to create a smaller subset of quotes for them to look through. In each Text Input field I had a formula akin to  If(!IsBlank(ExistingQuote.SelectedText.Value),LookUp('Dealer Support Services',ProjectName_DateTime=ExistingQuote.SelectedText.Value).TagFloor,"Tag/Floor") in the Default function.


The unintended consequence is that upon starting the app it overwrites all the fields with the first project in the list. For me this wasn't an issue as there was a blank line. I do not want to create a blank line for each user as that adds some errors into the list. I wanted to create a button that loaded the info from the list on demand. I created a button with the formula in the OnSelect function TagFloor.Text = LookUp('Dealer Support Services',ProjectName_DateTime=ExistingQuote.SelectedText.Value).TagFloor  but that does not seem to really do anything. I hit the button and nothing happens. I tried creating a new Label and seeing if I could update the text value in the label but still nothing.  I was wondering if anyone had any ideas as to what I am either doing wrong or another way to attack this issue.


Thanks in advance.

Super User
Super User


Sorry, but I am confused by this explanation of your issue.


  • What do you mean by overwrites all the fields with the first project in the list?
  • What do you want to happen instead?
  • Can you share some screenshots of your app showing what the issue is and what you'd like to have happen?
  • Please also supply any relevant code


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Thanks for getting back to me @mdevaney .

Hopefully, this helps. If you look at the png's attached, PowerApps-Defaults is what I see when I open the app but that is because the existing quote field is blank. It is blank as I have an item in our SharePoint list that is blank. However, others do not so when they open the app the existing quote field is populated which automatically populates the fields as shown in PowerApps-Projects. The end result of Projects is what we want but only if the user chooses a project, otherwise it should always open with all the default values.


I hope that helps.

Helpful resources

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,671)