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

View solution in original post

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.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 51 members 3,490 guests
Please welcome our newest community members: