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

(0) Share

Report

Posted on by Cyril06

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
Cyril06 159 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
Cyril06 159 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
Cyril06 159 on at

Like
a
(1)

Report
Copy link

Link copied!

oh !! Sorry I'm so newbie 🙄 😬
Thank you for all

Was this reply helpful? Yes No