I want to create an application that allows me to play mp3 audio files from SharePoint lists in PowerApps. I have loaded 5 audio files into the SharePoint list, but the issue is that when using the "audio" feature in PowerApps, the application only plays one audio file, and not the others, unless I manually select another audio track. However, my goal is for the application to play all the audio files randomly, meaning that when one song ends, it automatically plays another song from the SharePoint list randomly. Unfortunately, I haven't been able to achieve this.

Categories:

Connect to Your SharePoint List: Make sure your app can see the list where you've got your MP3s.
Pull the Songs into the App: When your app starts, pull in the list of songs into a collection (think of it as a basket of your songs inside the app):

Collect(MyMusic, SharePointList)

Randomize the List: You'll need to set up something to pick a song at random. There's no built-in "shuffle" button, so you'll be using a formula to pick a song by, say, its row number in the list.
Check When a Song Ends: PowerApps doesn't tell you when a song is done, but you can be clever with a timer. Set a timer to keep an eye on the song's progress—when it sees the song is at the end, it's time for the next one.
Play the Next Song: When the timer says the song is finished, your app should grab another song from your shuffled list and start playing it.
Keep It Going: Set everything up so once a song ends and the next one plays, the timer resets and gets ready to do it all over again for the next song.

Here's a nudge in the right direction for the formula to pick a random song:

Set(CurrentSong, LookUp(MyMusic, ID = RandBetween(1, CountRows(MyMusic))).URL)

Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

Music App: Unable to Play Multiple Songs from a List