cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

How to create a screen that can call back existing data inside SP list by matching?

Hi 

 

I had created a form edit that is for submission and edit

 

can I create another new screen in the same canvas to retrieve back existing data by inputting it's SP ID number or vendor name to show some data eg the description and amount with  it's attachment inside SP list whereby the user can submit another attachment into the same data for approval ? ?

6 REPLIES 6
Drrickryp
Super User
Super User

@bbsin 

You could put a dropdown and a form on a screen with your list as the Items property of the dropdown. The form should have it's datasource as the list. The item property of the form should be Lookup(yourlist, ID=Dropdown.Selected.ID).

Hi Drrickryp

 

I like to check I have a column called Vendor and it is a single text in SP

 

I added a dropbox in PowerApps for search selected is it possible?   

Lookup(list, Vendor = Dropdown1.Selected.Text) - this don't work.

 

 

Drrickryp
Super User
Super User

@bbsin 

That depends. Is it a list of vendors? Are there duplicates in your list?

There is no list of vendors, it all input by user

 

and yes there will be same vendor at somepoint of different rows.

Drrickryp
Super User
Super User

It's not clear to me if the Dropbox is inside the form or if you are using it to select the record for the form.

I want to be able to select the existing data inside the SP list to call back the item with it's attachment.

 

the SP list has ID, vendor name (single text) , description (single text) and attachment inside the list. and others..  

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,016)