You’re offline. This is a read only version of the page.
1,095
Can a Primary Column be a number of must it be a text? I have a vehicle fleet ID'd by numbers.
For your requirement to store vehicle fleet ID, the primary column can stay as text field because it allows alphanumeric characters to be entered.
Even if it wasn't a primary field, I wouldn't recommend using IDs as number field. The number columns are used where you need to do calculations/operations such as sum and average etc. A simple text column should suffice in your case.
I hope this information helps.
Thanks.
Gulshan
If this post helps, then please consider Accept it as the solution to help the other members find it.
@RJF61 - a Primary Name column can either be Text or Auto-Number.
You could still include your IDs in the Text field, but they will be read as Text. Depending on what you want to do, you could convert the Text field into a Number type in Power Apps/Power BI.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution
If you like my response, please give it a Thumbs Up.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
