Unable to create function because Data Type is stuck as Control

[Anonymous]

A user came to me with an issue when using a Sharepoint Integrated Powerapps Form. 

In a Date column, if a user accidently inputs the wrong date and submits (edits the sharepoint list item), they cannot remove the date but only edit it further. 

EG a user inputs the actual completion date and submits. Then realizes what he did and wants to remove it from the field in the edit form area. He removes it and hits submit, but it doesn't go away because the defaultdata is the existing date he wants to remove! 

So... My first thought was trying to play with the defaultdata but have no clue how to hack it with logic to be able to identify when a user is removing the data. 

Second option was creating user inputting control. So my logic was that IF progress is not equal to complete, then you cannot input an actual completion date. I would use this logic in the DisplayMode to say if that is the case, then the submit button is disabled, otherwise edit. 

I tried this, but it turns out my choice data card is considered to be a Data Type - Complex even though it is just 6 different choices (you can only select and submit one). I have had 0 success using value or text functions to change the data type from complex to text or value to be able to do this IF formula. I wasn't able to find any support online and have no clue why it is complex at all as it is a simple choice column in sharepoint. 

If anyone has a better way of doing this, or a way to fix the complex data type, please help! I am fairly new to Powerapps and the M language 🙂

[WarrenBelz]

Hi @Anonymous ,

Simply clear the date picker - put an X icon beside it with

UpdateContext{(varResetDate:true})

and the Reset on the Date Control

varResetDate

Also on your Screen OnVisible

UpdateContext{(varResetDate:false})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

Hi Warren! 
I will be testing this out this week. Thanks so much and will keep you posted.