Hi @Anonymous ,
1)Do you mean that the data format is not same in sharepoint list and custom form?
The reason why you met this problem is that the data format is different in these two places.
You need to set them separately.
If you want to set data format of sharepoint list, you could set it in list settings.
If you want to set data format of custom form, you could set it in that control's Default by using Text function.
For example:
Contract Value textinput's Default:
Text(ThisItem.'Contract Value',"[$-en-US]$#,###")
FO Commission textinput's Default:
Text(ThisItem.'FO Commission'*100,"[$-en-US]#%")
Total Order Commission Due textinput's Default:
Text(ThisItem.'Total Order Commission Due',"[$-en-US]$#,###.00")
2)Do you want to close the custom form when you save the data?
If so, set the SharePointIntegration's OnSave:
SubmitForm(SharePointForm1);Exit()
3)Do you want to make some datacards visible only if the %Due for #1 doesn't equal 100%?
Then you just need to set these datacards' Visible:
If(ThisItem.%Due=1,false,true)
Best regards,
