Hi, I am new to Power Apps and am struggling with a calculated field. I want to add a field that is created by adding days to a date value from a related table.
To do this - I have added a calculated field, which appears to find the date field on the related table because it lets me select it, but the resulting formula fails and it returns nothing
In desperation I have used the following formula to test if it finds anything:
If(IsBlank(Program.DATE),"nothing","YAY")
It doesn't, but it should because there is data present. The snip below shows the results - displaying 'nothing' next to the related field that it is checking (I have added that date field to the view) - it should display a 'YAY' So I have concluded it is not finding the date.
What am I doing wrong in my calculated field? How can I see the field yet not be able to calculate with it? Is it a problem with the Lookup?
thanks

Report
All responses (
Answers (