cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tmalone
Level: Powered On

Re: Date powerapps to excel | Just date, not time

So product lists: just the one "title" column containing on the different products. However, what would the productions lists look like? The relevant information for that list is date filled, quantity filled, and location filled, and product filled.

Super User
Super User

Re: Date powerapps to excel | Just date, not time

The production list would have all of the fields that you just described in addition to one extra field for "Product" which would be a lookup to the Products list
tmalone
Level: Powered On

Re: Date powerapps to excel | Just date, not time

Since the title colum is required how do it use that in the ProductTypes list? Currently the title column contains numbers to be a "key" for each type of product listed. So record one reads: 0 in the title column, and wiget x in the Products column. Is my thought process wrong on doing it like this or is there a better way?

Super User
Super User

Re: Date powerapps to excel | Just date, not time

So SharePoint already gives you a unique identifier for each item in a list. It's called the "ID" field and is hidden from the view by default but you can surface that up in your view. My suggestion would be to utilize that Title field to hold what you currently have in your "Product" Column.

tmalone
Level: Powered On

Re: Date powerapps to excel | Just date, not time

Awesome! Again thanks for all the help I really appreciate all the help you've provided!

Super User
Super User

Re: Date powerapps to excel | Just date, not time

No problem! Happy to help. Another cool thing you can do with SharePoint is Calculated Columns which allow you to mash up data from different columns.  For example, in your Products list you have your Title column which holds the product name (Widget X). And maybe you have another column for size (Small).  You can create another column which is a type Calculated COlumn and have a formula which combines the Title and Size like so =CONCATENATE([Title]," - ",[Size]) .  So your new column would have Widget X - Small. So in your Production list, you can add a Lookup Column to your Products Claculated column adn the user can select "Widget X - Small". 

tmalone
Level: Powered On

Re: Date powerapps to excel | Just date, not time

Ah ok thanks for the information!

Highlighted
PowerApps Staff Mr-Dang-MSFT
PowerApps Staff
Moved:

Re: Date powerapps to excel | Just date, not time

Moving this message so that it is at the top of its own post for discoverability. As a best practice, it's ideal to create your own post since your question may not be exactly as the original post.