Dynamics Community Forum Thread Details

D365 Expense Management Canvas App

Hi,

We are looking to implement the D365 Expense Management Mobile (Canvas) App. I have started configuring the app.

However, on the Reports - List Screen, it doesn't appear to be listing any of my expenses, even though I can see them in the "Expense Reports" dataverse table.

The formula for the "items" field for the gallery hasn't been changed from the base MS code, any help would be appreciated. The current code is:

SortByColumns(
    Filter(
        Switch(
            varcntSelectedStatus,
            1,
            Filter(
                'Expense reports (mserp)',
                'Document status' in dsDrafts[@Value]
            ),
            2,
            Filter(
                'Expense reports (mserp)',
                'Document status' in dsInReview[@Value]
            ),
            3,
            Search(
                Switch(
                    scr16_btn_DateFilter.Selected.number,
                    1,
                    Filter(
                        'Expense reports (mserp)',
                        'Document status' in dsApproved[@Value] && DateAdd(DateValue(ReportCreatedDateTime), 7, TimeUnit.Days) >= Today()
                    ),
                    2,
                    Filter(
                        'Expense reports (mserp)',
                        'Document status' in dsApproved[@Value] && DateAdd(DateValue(ReportCreatedDateTime), 30, TimeUnit.Days) >= Today()
                    ),
                    3,
                    Filter(
                        'Expense reports (mserp)',
                        'Document status' in dsApproved[@Value] && DateAdd(DateValue(ReportCreatedDateTime), 180, TimeUnit.Days) >= Today()
                    ),
                    4,
                    Filter(
                        'Expense reports (mserp)',
                        'Document status' in dsApproved[@Value] && DateAdd(DateValue(ReportCreatedDateTime), 365, TimeUnit.Days) >= Today()
                    ),
                    Filter(
                        'Expense reports (mserp)',
                        'Document status' in dsApproved[@Value]
                    )
                ),
                scr16_txt_SearchBox.Text,
                mserp_txt2
            )
        ),
        LegalEntity_DataArea = varSelectedLegalEntity
    ), 
    "mserp_reportcreateddatetime", SortOrder.Descending
)
 
Thanks.