I have earlier created an app based on Sharepoint lists.
Now I am about to change the app to be based on tables in Dataverse.
Everything was working fine when the sources were located in Sharepoint, but now when the sources are in Dataverse tables, the formulars doesn't work as before...
Somehow an error appears regarding dates...
The table (Tidsregistreringer) contains 3 columns where informations is stored regarding a date, the number of an employee and the number of hours:
Tidsregistreringer_Dato
Tidsregistreringer_Medarbejdernummer
Tidsregistreringer_Timer
The date is created by using the "Today()" function in Power Apps.
When I would like to retrieve the informations i a gallery in Power Apps I run these formulars:
Set(DefaultDateFrom; Today()-Weekday(Today())+2)
The gallery is to show the sum of the hours per employee on the specific date ("DefaultDateFrom")...:
The field with the number of hours are calculated as:
With({baseTable: Filter(Tidsregistreringer;Tidsregistreringer_Medarbejdernummer=ThisItem.Medarbejdernummer;Tidsregistreringer_Dato=DateAdd(DefaultDateFrom;0;TimeUnit.Days))};
Sum(baseTable;Tidsregistreringer_Timer))
The label that should show the number of hours in the gallery is empty....
If I remove the part with the date then figures appears.... So somehow the dates are causing the error...
How is that? - And how do I get it to work again?
(is there some settings, that changes when comparing Sharepoint and Dataverse?)
126
Share
Report
All responses (
Answers (
