web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Log/history for rental...

Power Apps

Answered

Log/history for rental app

(0) Share

Report

Report

Posted on by mrstian89

315

Hi! I am in the process of making a rental app for loaning out equipment at work.

I have one Sharepoint list with ItemNo, LoanStatus, among other information.

It is simple to create an app which tells us if the item is available or not.

But we need history. Who borrowed this item when?

My thought is to have another Sharepoint list for this and creata a new row every time an items is loaned out. The list will have columnns like:

ItemNo, DateBorrowed, PlannedReturn, DateActualReturn,BorrowedBy, among others.

In my scenario we will have one row in this list per rental per item.

My question:

Can anyone help me with the best way to write a new row to this list when someone is borrowing an item?
When returning the item, how do I make sure that I update the ItemNo row which is open/unreturned? And not the first ItemNo which was created in the log?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

MooseBot88 168 on at

Like (1)

Report
Copy link

Link copied!
Hi,

I know that one part of making a log of all equipment going out could be to patch it to a log,
Patch( sharepointlist, { ItemNo: textbox.value, DateBorrowed: textbox.value, PlannedReturn: textbox.value, DateActualReturn: textbox.value, BorrowedBy: textbox.value, } );

The textbox.value would be whatever your input would be. You could use an if statement to lookup the ItemNo and check whether a new column called LoanedOut is a yes or no. I'm not sure how would you do that but hopefully put you on the right track.

Was this reply helpful? Yes No

Join the conversation