Guys, please, urgent help!
I have a form, the submit function is the Submit.
I have 4 DateFields that my users fill.
Creating the form they fill a date, and on EditForm, they may erase the date they filled before, but here it is the issue, the field does not go to blank when erased and form is submitted, it is like the field is not erased.
I can erase it many times but the field remains with the date.
So, I searched here on forums and found a "solution", in a experimental Tool, that one with handling formulas error, I turned it on and this problem was solved, I erased and the field stayed blank as expected, BUT, It spoiled another thing in my form, I have a combobox that items property are Distinct of a table list in excel DS.
When the user create the form and select an value on combobox and submit, the value is ok on the editform, but when I save it again (submit again) on the editform, the combobox goes empty, the value of combobox disappear.
This is very strange, I will check for the combobox property for now on, but I am posting here to see if anyone had this issue before that could help me fix.
What is your data source of this Form? Please notice that if you want to use data from excel DS to update the data of another data source, most of the time we will use Patch function. This depends on what is your connection. For example, if it's a SharePoint list, then you cannot simply use the data from excel to multiple choice enabled column.
Humm, I think I got it.
The DS of the form is a Sharepoint list, and the Items Property of the CBox is from an excel Spreadsheet.
So in this case, I must use only patch, right?
@v-monli-msft I need to upload attatchment sometimes.
I searched that with patch can't upload attatchments to a SP List.
So I have a big limitation here, cant use patch and cant use the functionally to remove blanks because one thing mess up with another thing.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand