Answered

Is there a way to ask the user for a excel, then analyze the excel against a Microsoft List and then show an output of similar data ?

(0) Share

Report

Posted on by Mauser

I have a Power app, i want to make the app to ask for a excel to the user, once the user upload the Excel the app compare the Excel with a Microsoft List

The list have in common the name of a Ice Cream and the requested data, that is the excel that the user upload, and the available one, that is the Microsoft List data

Once the comparison finish, it need to show the difference of the requested and the available, that data can be positive or negative

Is there a way to do it in Power app, if not, what or how i can do it ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Use PowerAutomate to get excel data back to powerapps into local collection. Compare local collection against your list data source.

Was this reply helpful? Yes No
Mauser 34 on at

Like
a
(0)

Report
Copy link

Link copied!

And how I can do that, please elaborate

Was this reply helpful? Yes No
Verified answer

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
This is in assumption that uploaded excel has a table to deal with.
High Level Steps :
1. Using attachment control , ask user to upload file.
2. In OnAddFile method of your attachment control , call Power Automate and pass on the uploaded file to it as Parameter.
3. In Power Automate , Upload that file to either onedrive or SharePoint.
4. Use excel online connector to get rows from excel file.
5. Then use ParseJson to parse outpot of Get Rows.
6. Send that output as a response back to powerApps and assigned it to your collection.
Something Like This

ClearCollect( locExcelData, PowerAutomate.Run({File: File}).Output )

Was this reply helpful? Yes No