Power Platform Community Forum Thread Details

Hello everyone,

Recently I was tasked with converting a Power App built on SharePoint Lists to Dataverse Tables. Since Dataverse handles data differently than SharePoint Lists, there's been a lot of rewriting code for the various Data Cards in the App. I was able to rewrite most of it, but there is one formula I can't figure out.

Initially I had 3 SharePoint lists, 'Countries', 'Tasks', and 'Activities':

'Countries': the title column was populated with countries.
'Tasks': the title column was populated with tasks, and there was a lookup column called 'Country' that looked up country values from the 'Countries' list.
'Activities': the title column was populated with activities, and there was a lookup column called 'Country' that looked up country values from the 'Countries' list and another lookup column called 'Task' that looked up task values from the 'Tasks' list.
Each country had different tasks in list 2, and thus had different activities.

In my Power App, I had a Combo Box on the home screen called 'CountryComboBox' that was tied to the 'Countries' list. You would select a country to see the tasks and activities for that country in the subsequent screens. One of these screens had an edit form so users could submit activities to the activity list. This form had a Combo Box for tasks, and I filtered the choices for this to only show tasks for the selected country, with the following code set to the Items property of the combo box:

Filter(
    Choices([@'Activities'].Task),
    Not(
        IsEmpty(
            Filter(
                'Tasks',
                Country.Value = CountryComboBox.Selected.Title && Task.Value = Value
            )
        )
    )
)

I’ve migrated the data from the SharePoint Lists to Dataverse tables, with the same hierarchy/relationships. Now I’m trying to convert this formula to use the new Dataverse tables, but am having a lot of trouble getting it to work. I’ve tried:

Filter(
    Choices([@'Activities'].Task),
    Not(
        IsEmpty(
            Filter(
                [@'Tasks'],
                Task.Task = Task.Task && Country.Country = CountryComboBox.Selected.Country
            )
        )
    )
)

but this gives me the “We didn’t find any data” error message.

I’ve also tried:

Filter(
    Choices([@'Activities'].Task),
    Task in Filter(
        [@'Tasks'],
        CountryComboBox.Selected.Country = Country.Country
    ).Task
)

but this gives a “Can’t convert this data type. Power Apps can’t convert this Text to a Record” error on the Task in the "Task in Filter..." part.

To summarize, I'm trying to filter a combo box to only show task values for the selected country with Dataverse tables as the data source, but have been unable to figure out how to accomplish this for the past few days.

I would greatly appreciate any help any of you can provide on this matter. Thank you in advance!

Categories:

Building Power Apps