Share
ReportHello Community,
In SharePoint, I have two lists.
Form_Submissions contains "Business" choice column.
Structure contains "Country", "City", "Business" and "Description".
I have built a form with
DataCard1 - Country
DataCard2 - City
DataCard3 - Business
Under DataCard3 ComboBox, I need to display both "Town" and "Description".
Hence, I have come up with the items as:
Sort(Filter('Structure',Country=DataCard1Field.Selected.Value, City=DataCard2Field.Selected.Value),'Town'
This formula had allowed me to display both 'Town' and 'Description' to my users in the form.
However, this has caused the Update to be invalid as 'DataCard3Field.Selected' is a record and cannot be inputted in the SharePoint list when the column is a choice.
When I tried to make it into a record {Value:DataCard3Field}, it works.
However, even if the Required is set as true, and I do not input any value, Submit button to submit the form works.
Mandatory field no longer applies.
Please advise.
All responses (
Answers (
416
