Answered

Arrays Within Power Apps

Like (0) Share

Report

Posted on 21 Jun 2024 15:48:34 by David_Howarth

Hi,

I have a Power App function that takes a unique variable from the app, such as a surname, and searches an Excel spreadsheet for a match. (There can only be one) It retrieves the entire row of matching data via Power Automate. So far, so good. I have returned the array to Power Apps as text using Power Automate's Return to Power Apps function (is this my first mistake?) and now I'm wondering how to access the array within Power Apps. I've tried using collections and index functions, but with no success.

i.e.

ClearCollect(loadDataCollection, personalData.Run(Surname.Value));

Set(Firstname.Value, loadDataCollection[0]);

Wondered if anyone could point me in the direction of an array help file or had a tip as to what the bump in this app's road is?

Many thanks for any help,

David

Categories:

General Questions

Dataflows

All responses (2)

Answers (1)

David_Howarth on 21 Jun 2024 at 20:36:00

Like (0)

Report

Re: Arrays Within Power Apps

Thank you for these and will deeper dive when up to this level of programming.
Verified answer

ANB 7,075 Super User 2025 Season 1 on 21 Jun 2024 at 16:13:27

Like (0)

Report

Re: Arrays Within Power Apps

Hi @David_Howarth , You can use MatchAll function. Please check this YT video: https://www.youtube.com/watch?v=N1pPUvFeWUk

You can also use Response action however it will require premium license. Please check this https://powerusers.microsoft.com/t5/Building-Power-Apps/Pass-Array-from-flow-to-PowerApps/td-p/404570

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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

Thanks,
ANB