Announcements
Hi all, Relatively new to PowerApps and have been stuck on this for a day or so now. I'm building an Asset Management App for our Service Desk, we can scan asset tags and assign them to the device the sticker is on (laptops and the like). This information is stored in a list called Assets. When we assign the asset to a staff member I want to update a field in Assets which is simple using the form. When we remove an Asset from a staff member I want to clear the 'AssignedTo' column in Assets and also create an entry in another list called Asset History so that we have information on users past assets or the history of an asset. Within the second list I have a LookUp on the SerialNumber which works, i just can't for the life of me get the information to populate from the submit button on the form, as the form relates to the Assets list. I'm under the impression i need to use Collect to collect the data on the OnSelect of the submit button but the sources i'm looking at don't seem to be working. Any ideas would be greatly appreciated.
Hi @MattW1 ,
May I ask what you use to populate the second list? Is it a form or via a Patch function?
In case it is a Patch function, this article may be of use to you: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-lookup-column-in-power-apps/
Hi @BCBuizer It was by a form, I've found a workaround whereby creating a flow can do the work in the background when form 2 has been submitted. But i'm running into issues with that as well, I have a SP List named Asset History and when an item is created or modified where ReturnedDate is not null I want to take the SerialNumber from that record and use it to locate a record in a SP List named Assets and change the AssignedTo and AssignedDate fields to NULL.
I'm running into lots of issues with array/string and have tried multiple variables and methods. can't seem to get it working! The show goes on!
What you can do for the scenario you described in your latest post, is to use a conditional Patch function in the OnSuccess property of the form that is linked to the 'Asset History' list:
If( !IsBlank(Self.LastSubmit.ReturnedDate), Patch( 'Assets', LookUp( 'Assets', SerialNumber = Self.LastSubmit.SerialNumber.Value ), { AssignedTo: Blank(), AssignedDate: Blank() } ) )
For this to work, Formula Level Error Management should be enabled under Settings / Upcoming Features.
@BCBuizer Thank you so much for the knowledge sharing, I hadn't explored the Patch function before. This eliminates the need for flows on some of my other pages! Thanks again mate, really appreciate it.
Happy to read this helped you do things more efficiently. 😀
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
