Unanswered

Switching Data Source Excel to SharePoint List | Tips and Best Practices | Challenges with column data types in SharePoint List

(0) Share

Report

Posted on by safifaruqi

Good Day Guys,

I have a fully functioning Issue Logging/Ticket Tracking app which is presently connected to a table in EXCEL and due to sacalability issues. I would like to transition to SharePoint List as the data source for the app.

When I export the excel sheet out to the share point list I am met with a few issues :

- Issue number 1 : some column types that are setup as date are being converted into 'Single Text' or 'Number' columns and the sharepoint list does not allow me to change it to date and time.

- secondly, when I connect the sharepoint list to my app, all the data cards go wonky, that is understood, but I cant seem to reference the sharepoint list and update data card, when I replace the reference from excel to the sharepoint list name in the code, I am still getting the an error as if the reference is unrecognizable to my app.

lastly, is there an easier to do it? or will have to change reference for each data card in my app to point towards the sharepoint list?

Thank you for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @safifaruqi ,

Firstly, did you use "Import spreadsheet" to set up the SharePoint list?

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report

@WarrenBelz hello sir,

Yes I did, i tried both the export out of excel and import which I understand to be an upload of the excel sheet on the sharepoint url to convert table in the sharepoint list.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @safifaruqi ,

Firstly, forget the first one (export from Excel) as it creates a list that has some incompatibilities with things you might want to do. Importing from Excel via "create app" generally does the job, but I normally go a step further and create a new list in SharePoint, then create a Datasheet view with the same column order and paste in the data from Excel.

Providing you have kept your field names and types and names the list the same as the table name in Excel, it should come across reasonably well.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report

@WarrenBelz
Pardon my ignorance. I have never really used sharepoint for anything so a little knew to this. are you referring to the following
New > App and then > custom list in datasheet view?

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @safifaruqi ,

You can do it from the top menu as below

or new custom list (either normal or data sheet view if that is what you want)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report

Hi @safifaruqi ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report

Hi @WarrenBelz,

Will setup a solution today and let you know how it worked out.

appreciate the support and follow-up. Will Keep you posted.

Safi

Was this reply helpful? Yes No