Thanks for the mention @WarrenBelz.
@Eeyore2005 -
As I understand it.
You have a SharePoint List. That list contains a field called "Saved as New" and a field called "Person Saved as New". The data type for both fields are Single Line Text.
Looking at the screenshot, I also presume the DataCard hosting the Toggle control is bound to a field in your SharePoint List (presumably a Yes/No data type).
When that Toggle control is checked, the "Saved as New" DataCard should display the date that toggle was checked, and the "Person Saved as New" DataCard should display the email address of the User who made that change.
Unless the Toggle is unchecked, the "Saved as New" and "Person Saved as New" fields should remain static and should not change with every edit made to the record.
For this I would suggest taking a step back and focus on what you're trying to do, rather than trying to fix your current solution.
Consider the steps below:
1. Ensure the default setting for the Yes/No field is No in SharePoint.
2. On the Default property for the "Saved as New" DataCard (not the DataCardValue), enter:
If(
!('Toggle_Change to New'.Value),
Blank(),
If(
IsBlank(ThisItem.'Your Saved as New Column'),
Now(),
ThisItem.'Your Saved as New Column'
)
)
3. On the Default property for the "Person Saved as New" DataCard (not the DataCardValue), enter:
If(
!('Toggle_Change to New'.Value),
Blank(),
If(
IsBlank(ThisItem.'Person Saved as New field'),
User().Email,
ThisItem.'Your Person Saved as New field'
)
)
Note:
Keep everything else as default. For example do not make any other modifications to the DataCards.
There is no need for the variables.
If you're not using a Yes/No data type, but Single Line Text or Number for example, you will need to adjust the above formulas to accommodate those data types.
