Hi @Anonymous ,
Could please share a bit more about your scenario?
Do you use the IF function in your Excel table to calculate the Column D value (calculated column)?
Further, do you would like the Calculated column (Column D) to be populated automatically within your app?
Based on the needs that you mentioned, I afraid that there is no way to achieve your needs in PowerApps currently.
Firstly, within PowerApps, we could not create a connection to a Excel table which has a calculated column from a canvas app currently.
In addition, the Excel formula (e.g. IF function that you mentioned) would also not be applied to a canvas app.
As an alternative solution, you could consider do the calculation operation for Column D within your canvas app rather than use the Excel formula in your Excel table itself.
I have made a test on my side, please take a try with the following workaround:
My Excel Table as below:
Note: The Start date planned column and Start date real column are both Date type columns in your Excel table.
My App's configuration as below:
On your side, you could generate an app based on your Excel table, then it would generate three screens automatically as above I mentioned.
Within the Edit form of the Edit screen, set the Update property of the Column D Data card to following:
If(
IsBlank('Start date real _DataCard2'.Update),
"",
If(
'Start date real _DataCard2'.Update < 'Start date planned_DataCard2'.Update,
"started before",
0
)
)
Note: The 'Start date real _ DataCard2' represents the Start date real data card in your Edit form, the 'Start date planned_ DataCard2' represents the Start date planned data card in your Edit form.
Please check the following screenshot for more details:
More details about generating an app based on Excel table, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-data
Best regards,
