web

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

News and Announcements icon

Power Platform CommunityForums Power Apps only be able to edit l...

Power Apps

Answered

only be able to edit last trip

(0) Share

Report

Report

Posted on by ShivaShibshib

7

Hi,

We created logbook and we set up the rule if the "End KM" is only blank then user can edit the form. Otherwise they will not be able to edit once they filled the form. However now we have some issue that users are making lots of error and they need to back and fix the issue but we don't want the edit all entries.

I was wondering if someone could show me how we can let the use edit last two entries.

If(IsBlank(ThisItem.EndKM), Navigate(srn_enterReading)); The Gallery already use filter option based on latest "DateOfTrip"

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,584 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ShivaShibshib ,

Try this on the OnSelect of the Gallery (then have an Edit screen available)

With( { wLast2: With( {wList:YourListName}, FirstN( Filter( Sort( wList, ID, Descending ), 'Created By'.DisplayName = User().FullName ), 2 ) ) }, If( !IsBlank( LookUp( wLast2, ID = ThisItem.ID ).ID ), Navigate(YourEditScreen) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
ShivaShibshib 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you so much, It was successful. I just going to test it now.

Join the conversation