Answered

Converting existing powerapp from Sharepoint List to Dataverse table.

(0) Share

Report

Posted on by DaveHouser

I have an app that is working properly using a Sharepoint List. I have created a Dataverse table for it because it's growing too large for the app. I've swapped the Data connections but now the BrowseGallery does not populate properly and the formula is throwing errors as I'm trying to substitute the new table for the old List.

Here is the formula that works properly using the Sharepoint List:

SortByColumns(
If(
showComplete=true,
Filter(
[@'Brightspeed Fiber OFS Validation'],
StartsWith(
olt_clli,
TextSearchBox1.Text
)
),
Filter(
[@'Brightspeed Fiber OFS Validation'],
StartsWith(
olt_clli,
TextSearchBox1.Text
) && 'OLT Port Status'.Value=Blank()
)
),
"Title",
If(
SortDescending1,
SortOrder.Ascending,
SortOrder.Descending
)
)

Can someone assist me with what needs to be changed to support the Dataverse table? Simply substituting the names is not working....

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@DaveHouser - you have not stated what the data types are for the fields you're filtering on (Single line Text, Number, Date, Choice etc). These work differently depending on your data source.

Assuming the "olt_clli" field is a Single Line Text field in both your SharePoint and Dataverse tables, and assuming "OLT Port Status" is a Single-Select SharePoint Choice field, you will need to modify the syntax for the equivalent Single Select Dataverse Choice field I assume you created.

In addition, I suspect the "Title" field is wrong in your SortByColumns function. You will need to enter the Logical Name for that field rather than Display Name. You can find the Logical name by right clicking the column from the Dataverse table, selecting Edit column, and then looking at the Logical Name:

Further reading: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators#display-names-and-logical-names

Suggested code:

SortByColumns( If( showComplete = true, Filter( 'Brightspeed Fiber OFS Validation', StartsWith( olt_clli, TextSearchBox1.Text ) ), Filter( 'Brightspeed Fiber OFS Validation', StartsWith( olt_clli, TextSearchBox1.Text ) && 'OLT Port Status' = Blank() ) ), "Logical Name for the Title field", If( SortDescending1, SortOrder.Ascending, SortOrder.Descending ) )

Was this reply helpful? Yes No
Verified answer

DaveHouser 20 on at

Like (1)

Report
Copy link

Link copied!

Thank you. That did the trick! Big learning curve for me as I'm jumping into this in the middle of things and learning as I go. Dataverse also evidently hates brackets...

😉

Thanks, again!

Was this reply helpful? Yes No