Unanswered

Circular Reference Error

(0) Share

Report

Posted on by greddin

112

On the DefaultDate property of a Date field I have (DataCardValue13) I'm trying set the default date to Today - only if this is the editform and the current date is empty. But I'm getting the following error.

This rule creates a circular reference between properties which is not allowed.

Here's my formula:

If(SharePointForm1.Mode = 0 && IsBlank(Self.SelectedDate),
 Today(),
 Parent.Default
)

How do I reference the current field this formula is on? It doesn't like the Self.SelectedDate currently.

Thanks

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@greddin

First, before investigating other aspects that might be at play, change your formula to the following:

Coalesce(Parent.Default, Today())

If that doesn't resolve it, then please provide the Default property of your Datacard.

I hope this is helpful for you.
greddin 112 on at

Like
a
(0)

Report
Copy link

Link copied!

The Coalesce you gave seems to work without error. But I loose the ability to check if the form is in edit mode. This is a SharePoint custom PowerApp form.

The Default property of the datacard is: ThisItem.'Completed Date'

Thanks again
greddin 112 on at

Like
a
(0)

Report
Copy link

Link copied!
This seems to work so maybe this is how I should I done it?

If(SharePointForm1.Mode = 0 && IsBlank(Parent.Default), Today(), Parent.Default )
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@greddin

What would be the difference in the mode? Are you trying to preserve blank values if editing a record?

If so, then you can revisit your formula (in which the issue was your reference to Self)

Your goal is to preserve a blank date if editing, then the better choice is to not reflect on the form mode, but instead the underlying record.

The formula would then be:

If(!IsBlank(ThisItem.ID), Coalesce(Parent.Default, Today()) )
greddin 112 on at

Like
a
(0)

Report
Copy link

Link copied!

My goal is to set the default date for the date field to today's current date. But only if the form is in edit mode. My reasoning for this is if there is already an existing date value then I don't want to overwrite that with the new date but perserve it. This is why I am concerned about the edit mode. Thanks for your thoughts.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@greddin

Yes, so that last formula I presented to you will do exactly that. Don't rely on your form mode though like that as you are stating this:

"if there is already an existing date value then I don't want to overwrite that with the new date but perserve it. This is why I am concerned about the edit mode."

You CAN be in edit mode with a new record!! So, if you rely on the mode, then your formula would fail. If instead you look for the existence of the actual record (your record would have an ID if it exists and would be blank if not), then you will not go wrong!

That is what that formula does.