issue with data table

(0) Share

Report

Posted on by hcharrisbna

I have a data table that works perfectly with the following:

Sort(Filter(Projects,StartsWith(StateProject,drpStateList_1.SelectedText.Value),Status1="Active"),ProjectName)

I want to add a blank row at the top of the list.

So I added the following:

Ungroup(
Table(
{WFPOOptions: Table(
{State: Blank()},
{ProjectID_static: Blank()},
{ProjectName: Blank()})},
{WFPOOptions: Sort(Filter(Projects,StartsWith(StateProject,drpStateList_1.SelectedText.Value),Status1="Active"),ProjectName)}),
"WFPOOptions")
)

This doesn't work at all. No data is presented.

The first column is a dropdown in the SharePoint List. Could that be a problem?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @hcharrisbna ,

Try a gallery instead - Data Tables are not always reliable with complex Items

Was this reply helpful? Yes No
hcharrisbna 32 on at

Like (0)

Report
Copy link

Link copied!

I created a gallery and was able to use a filter but not able to add a blank row at the top. When I add the code above, no records are returned, same result as using the data table. Thanks for the reply. Any other suggestions?

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @hcharrisbna ,

Try this - I tested here with similar value types and got the expected result.

Ungroup( Table( { WFPOOptions: Table( { State: Blank(), ProjectID_static: Blank(), ProjectName: Blank() } ) }, { WFPOOptions: Sort( Filter( Projects, StartsWith( StateProject, drpStateList_1.Selected.Value ), Status1 = "Active" ), ProjectName ) } ), "WFPOOptions" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
hcharrisbna 32 on at

Like (0)

Report
Copy link

Link copied!

I'm sorry to say, still no joy. Result the same: nothing returned to the gallery.

Thank you for the response and for trying.

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @hcharrisbna ,

Does this return anything ?

Filter( Projects, StartsWith( StateProject, drpStateList_1.Selected.Value ), Status1 = "Active" ) )

Was this reply helpful? Yes No
hcharrisbna 32 on at

Like (0)

Report
Copy link

Link copied!

I had to change your code to:

Filter(Projects,StartsWith(StateProject,drpStateList.SelectedText.Value),Status1="Active")

and that runs. When I add the Sort:

Sort(Filter(Projects,StartsWith(StateProject,drpStateList.SelectedText.Value),Status1="Active"),ProjectName)

it runs. It's when I try to add the blank values for the first row that it fails:

Ungroup(
Table(
{
WFPOOptions:
Table(
{
State: Blank(),
ProjectID_static: Blank(),
ProjectName: Blank()
}
)
},
{
WFPOOptions:
Sort(
Filter(
Projects,
StartsWith(
StateProject,
drpStateList.Selected.Value
),
Status1 = "Active"
),
ProjectName
)
}
),
"WFPOOptions"
)

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@hcharrisbna ,

Try it with just blank for State - the others should be blank by default in that record when the rest of the table records are created.

Was this reply helpful? Yes No
hcharrisbna 32 on at

Like (0)

Report
Copy link

Link copied!

That appears to be working. I want to test some more but .... stay tuned.

Was this reply helpful? Yes No
hcharrisbna 32 on at

Like (0)

Report
Copy link

Link copied!

After some quick testing, kudos to you, that fix worked. Thank you!!!

There are many things about Powerapps that don't seem to make sense to me. After the change you suggested, one of the columns being displayed had no data. Fiddling around with the items list, I found that the column in the SharePoint list was not available when I tried to relink it. The column, through trial and error, was finally located as "(Name)", not the column name in SharePoint. This makes no sense to me just as removing the two columns in first line of the Ungroup command made no sense. If you have any explaination i would like to hear it to improve my understanding.;

Thanks again for your help. I really appreciate it.

Carter

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @hcharrisbna ,

Sorry I have not come across that one before

Was this reply helpful? Yes No