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 : ltex28CHNxLkK8ZRH68O1d
Power Apps - Building Power Apps
Answered

PowerApps / Excell / Sharepoint am I choosing the right pattern?

Like (0) ShareShare
ReportReport
Posted on 31 May 2020 17:54:07 by 159

Hello everybody and first I hope you 're well and excuse me for my bad english ...

 

I have a great Excel Planning file with macro, userforms etc...

This file is hosted into my company Sharepoint

This is a multi-users files

 

I want the drivers to see their deliverys in PowerApps

I created the App it's ok but I have a big trouble to synchronise the different things

A DataBase for all the deliveries , an other Databse with the different drivers and the App.

 

When I created the connexions I choose Excel Files but it's not updating

PowerApps didn't creat is  "__PowerAppsId__" column

 

Do you think it's coming from the .xlsm ?

 

What is the most secure way to create it with a big .xlsm file?

 

Thank you for your time

Categories:
  • Cyril06 Profile Picture
    159 on 01 Jun 2020 at 11:43:09
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    oh !! Sorry I'm so newbie 🙄 😬

    Thank you for all

  • Verified answer
    mdevaney Profile Picture
    29,987 Moderator on 01 Jun 2020 at 11:41:17
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    @Cyril06 

    That's a question for the Power Automate forums.  If you want to sync an Excel table with a SharePoint list you'll need to use that app instead.


    Link to Power Automate Community
    https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Cyril06 Profile Picture
    159 on 01 Jun 2020 at 11:38:59
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    Thank you for this but i allready did it and my question was what's the way to update it every new entries?

  • mdevaney Profile Picture
    29,987 Moderator on 01 Jun 2020 at 11:19:37
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    @Cyril06 

    To import a spreadsheet to SharePoint, create an Excel Table of your data.  Then click on the Table tab and find the Import To SharePoint buttton.

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Cyril06 Profile Picture
    159 on 01 Jun 2020 at 07:34:48
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    Thanks a lot for your advise it's really new for me all this thing

     

    I allready tried to do a Sharepoint List in fact I did it before but I let it because I don't know how to synnchonise it:

    When I update my Excel file how can I do to update the Sharepoint list ?

    Is it automatic ?

    Is that with an click somewhere ?

    Can I do it via a VBA Macro?

     

     

  • mdevaney Profile Picture
    29,987 Moderator on 31 May 2020 at 19:44:42
    Re: PowerApps / Excell / Sharepoint am I choosing the right pattern?

    @Cyril06 

    Big Excel files are not really great when working with PowerApps.  If you have over 2,000 records you will never be able to read-in more than 2,000 records into your app.  I would suggest you import the Excel sheet into a SharePoint list and use it as the datasource instead.

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete