You’re offline. This is a read only version of the page.
I am using the following condition in the Text property of a Gallery Label field.
When the Gallery fields are populated with data there is no error (in development view).
When there is no data in the Gallery fields the error (shown below) appears.
Gallery / DaystoRenewalFld / Text Property:
Lookup(DaystoRenewalCollection,ClassTitles=ThisItem.CQTitle).DaystoRenewal - DateDiff((ThisItem.DteofCQ),Today(),Days)
Power Apps Error Message:
"The first argument to the DateDiff function cannot be blank."
Hi @Phineas ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@Phineas ,
That is because DatDiff() requires a date to be valid. Try this
Share
Report
All responses (
Answers (
If(
Value(ThisItem.DteofCQ)>0,
Lookup(
DaystoRenewalCollection,
ClassTitles=ThisItem.CQTitle
).DaystoRenewal -
DateDiff(
ThisItem.DteofCQ,
Today(),
Days
),
0
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
