web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Edit Screen Doesn't Ma...

Power Apps

Answered

Edit Screen Doesn't Match on Random

(0) Share

Report

Report

Posted on by ubikwitous Microsoft Employee

I have a SharePoint list, where I'm letting people search. There is a button they can use to navigates to a different screen that will surface 1 random item from the list. That screen is generated by:

FirstN(Sort(AddColumns ('Data Source', "Random", Rand()), Random), 1)

When I'm on the Random Screen and I pick the > to edit or view the list item, it goes to a different list item! I've tried both:

Navigate([@DetailScreen1])

and

Select(Parent)

Does anyone know where I've gone wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!
@ubikwitous
There's a simpler way. When dealing with records you can use SHUFFLE to re-arrange their order randomly.

Shuffle('Data Source')

---
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."

Was this reply helpful? Yes No
ubikwitous Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I got there based on what you wrote - thanks!

Was this reply helpful? Yes No

Join the conversation