web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Connecting to a file a...
Power Apps
Answered

Connecting to a file after selecting file in gallery

(0) ShareShare
ReportReport
Posted on by dejan 45

Hi All, 

 

 

 

I have a requirement that users need to upload an excel file to some location, we have chosen a dataverse table and file column and that is working fine. 

 

The issue is that no we need to be able to select that file or any other file from the table and to use data that is in that file for some calculations.

I have tried everything that I can think of and find and non of the solutions is working. My idea is to somehow bring data from a selected file to a collection but non of the solution is working

Does anyone have any idea how this can be done?

 

Categories:
Building Power Apps
  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi XX, 

     

    Do you want to get the table in an excel file which user selected in the canvas app and then save the table into a collection?

     

    If so, I'm afraid it is not available for now. But you can create a new idea through the below URL, then ask  your colleagues to raise up the votes.  

     

    Power Apps Ideas - Power Platform Community (microsoft.com) 

     

    The  product team has direct visibility of these ideas and they will implement it on the basis of the highest number of votes received. 

     

     

    Best Regards, 

    Bof 

  • Verified answer
    dejan Profile Picture
    dejan 45 on at

    We find solution by using dataflow we extract all data from files in one table, that table will hold all extracted data along with some files identificator (GUID,name) and than when we select certain file we are using GUID to filter that table and load desire data . 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans