Answered

Arrays Within Power Apps

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David_Howarth on at

Like (0)

Report

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

Was this reply helpful? Yes No