Power Platform Community Forum Thread Details

I have a spreadsheet in excel which has over 200 rows, which will need updating annually. The issue is I would like this in a Sharepoint list for selected people to update their relevant figures however one column has multiple data types e.g. currency, number, percentages.

Not sure if there is a way to set each row as their own type or use a few separate lists and merge them into one.

Thank you in advance

Categories:

General topics

HI @kaycon86

Let's clarify, rows do not have data types, columns do. So I am no sure what you mean by each row its own datatype.

Unless you mean that in the one (multi type) excel data, you want to create say

CurrenCy Column

Text Column

Etc..

And then take the Multi-type excel and parse it and put each line there into the different columns

If thats the question, Yes you can. You just need to parse the lines properly but after that its easy.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey