cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Need A Lot of Baby Help With This...SQL Server, Date Picker and Details Card

Hi All

 

In the past I have made some very basic PowerApps with a lot of help from this community.  I want take a moment to thank all of you for that.

 

I am sorry I find the whole PowerApps platform counter intuitive to my mind and I really struggle with it.  I have tried the training and used a fair amount of youtube help, been to the app in a day training and I still struggle with this.  I think its because I am starting from an on premise SQL Server rather than something simpler to apply.  Either that or I am trying to apply steps to stuff beyond what a beginner may normally be expected to apply.

 

What I am wanting to do.

 

I have a view in SQL that lists purchase orders and purchase order details.

 

I made a simple PowerApps so my team can see from their phone what I have ordered for them.  That works fine.  

 

The way the view works is if the job is open it shows all items I have ordered for the job.  Once the job closes the order is no longer displayed.  This works fine and for the majority of the purpose is appropriate.

 

However the view also displays stock orders.  And unlike job orders Stock never closes.

 

I thought it would be pretty good to add a date picker to the details screen so the person viewing the record in powerapps could mark the item as received.  This would then update via the view and I could then code the view to remove received items.

 

To do this I added a datacard to the display form

ReceiveDate_DataCard1

 

Within ReceiveDate_DataCard1 I inserted a date picker I called the date picker dtReceived, then changed the data card to make it editable.

 

Within ReceiveDate_DataCard1 I have set the data field to ThisItem.ReceiveDate

 

I would have thought thats all I need to do.  However on testing I am getting the date saving within the PowerApps during design work, meaning I update ReceiveDate_DataCard1 in the date picker to say 2nd of July it shows 2nd even after I close and reopen it.  However when I go to SQL and look the date is still Null on SQL.

 

How do I tie the date picker date back to ReceiveDate in the SQL view?  What setting do I need to apply where and more importantly why am I applying this setting?  Sorry if this is a bit unclear I am trying to make it clear.  Here are some screen shots if more helpful than my bad explanation:

 

Details CardDetails CardDate PickerDate Picker

 

Please ask questions if need to clarify?

 

Thanks

 

4 REPLIES 4
Highlighted
Super User
Super User

Re: Need A Lot of Baby Help With This...SQL Server, Date Picker and Details Card

Hi @dynamictiger 

The most important aspect is the Update property of the card containing the control.  It should be something like ReceiveDate_DataCard1.SelectedDate 

Highlighted
Helper I
Helper I

Re: Need A Lot of Baby Help With This...SQL Server, Date Picker and Details Card

Thanks Drrickryp.

 

I think this is where I am getting tied up.  The screen is the default detail screen.  The card doesnt seem to offer an update option.  Do I need to build a new screen or change the card or...?

Highlighted
Super User
Super User

Re: Need A Lot of Baby Help With This...SQL Server, Date Picker and Details Card

It needs to be an edit form on the screen

Highlighted
Helper I
Helper I

Re: Need A Lot of Baby Help With This...SQL Server, Date Picker and Details Card

Sorry if this is a bit simplistic but adding an edit form opens up all the record to edit.  I only want date received updated.

 

is there an alternative way using detail form and a button for example?

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,461)