I am struggling with this Function to show an object as Visible (on a Calendar) by attempting to access a View that I have published for a Dataverse Table:
CountRows(
Filter(
Sort(
'Dataverse Table Name (Views)'.ViewName,
Due_Date,
SortOrder.Ascending
),
(DateValue(Text(Due_Date)) >= DateAdd(Today(), -120, TimeUnit.Days) &&
DateValue(Text(Due_Date)) <= DateAdd(Today(), 365, TimeUnit.Days)),
(DateValue(Text(Due_Date)) = DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
)),
(Lower(Email) = Lower(Delegated) ||
Lower(Email) = Lower(Allocated) ||
Lower(Email) = Lower(Administered) ||
Lower(Email) = Lower(Managed) ||
Lower(Email) = Lower(Reporting) ||
Lower(Email) = Lower(Governed))
)
) && !Subcircle2.Visible && Title6.Visible
In one instance, PowerApps validates by allowing me to add the View Name, by showing it as one of the valid items in the selection panel at the bottom of the function panel - but then it tells me it is not valid - and that none of the Column Names I am using from the View are recognized.
I thought it might be because I am attempting to Filter > Sort a View (?), which I then removed, like this:
CountRows
( 'Dataverse Table Name (Views)'.ViewName,
(DateValue(Text(Due_Date)) = DateAdd(
_firstDayInView,
ThisItem.Value,
TimeUnit.Days
)),
(Lower(ELC_Email) = Lower(Delegated)
|| Lower(ELC_Email) = Lower(Allocated)
|| Lower(ELC_Email) = Lower(Administered)
|| Lower(ELC_Email) = Lower(Managed) ||
Lower(ELC_Email) = Lower(Reporting) ||
Lower(ELC_Email) = Lower(Governed)))
&& !Subcircle2.Visible && Title6.Visible
But still PowerApps allows me to add the View Name and then tells me it is not recognized - along with not recognizing any of the Column Names.
Is my syntax to refer to a Dataverse Table View correct or should I be using some other method?
Thanks!
