CRM Crate

How to shuffle the data in a collection using Shuffle() function in Canvas App?

We will understand and learn to shuffle the data in a collection using Shuffle () function in Canvas App. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Platform.

How to shuffle the data in a collection using Shuffle() function in Canvas App?

What is Power FX?

Microsoft’s Power Fx is the low-code language that will be used across Power Platform. It’s a strong-typed, general-purpose, declarative, and functional programming language. Power Fx is expressed in user-friendly text. It’s a low-code language that citizen developers & makers can work with directly in an Excel-like formula bar or Visual Studio Code text window.

It enables a complete range of development from no-code for those who have never programmed before to “pro-code” for the seasoned professional, with no learning or rewriting cliffs in between, enabling diverse teams to collaborate and save time and expense.

canvas app shuffle function

Understanding Shuffle function in Power Apps

Syntax:

Shuffle( Table )

This function is used to randomly re-order the rows or records of a table or collection. Shuffle returns a table that has the same columns and number of rows as the argument.

Example:

  • Sometimes we need to mix the data of a collection or a table as per business needs. Consider a real-time example of quizzes where we need to shuffle the sequence of answers every time the quiz gets launched. Such requirements can be fulfilled using the Shuffle () Power FX function.

ClearCollect( NewCollection, Shuffle(Collection))

This function will collect the data from input collection, shuffle it and return the mixed data to a new collection.
  • The below animation represents the implementation and usage of Shuffle () Power F X function in Canvas App.
canvas app shuffle data

Thus, we learned to shuffle the data in a collection using Shuffle () function in Canvas App.


5 1 vote
Article Rating
Subscribe
Notify of
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
error: CRM Crate Security Engine - Disabled Right Click & Selection!

Congratulations!

Well Done,
Welcome to CRM Crate

Stay tuned with us and get all latest updates and learning in Microsoft CRM and related techonologes.