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

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Connecting to multiple excel data sources in runtime dynamically in Power Apps Canvas App

(0) ShareShare
ReportReport
Posted on by 16

Hi,

 

I have a requirement where we need to create excel data source for each user in organization and then need to apply crud operations with in that using canvas app. Do we have any approach to implement this scenario by dynamically connecting to excel data source tables within canvas app. 

 

Thanks,

Vamshi

I have the same question (0)
  • eka24 Profile Picture
    20,921 on at
    Re: Connecting to multiple excel data sources in runtime dynamically in Power Apps Canvas App

    Am wondering why you want a different table for each user. Instead you can create a column in one table for User names. Then on your form that field Will hold or contain the user names as they enter Data.

    If you want to view Data you could filter the table so each user is able to view his or her own record.

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

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 663 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 398 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard