Export Gallery Filtered Data

(1) Share

Report

Posted on by Petrusottie1

Hi,

Please assist, I have powerApp gallery that I need to export its filtered data, here's is my code so far:

ExportFilteredTickets.Run(Filter(Tickets,

And(

Or(

IsBlank(dpStartDate.SelectedDate),

DateCreated >= dpStartDate.SelectedDate),

Or(IsBlank(dpEndDate.SelectedDate), DateCreated<=dpEndDate.SelectedDate),

Or(IsBlank(drpStatus.Selected.Status),Status = drpStatus.Selected.Status),

Or(IsBlank(drpSortByUnit.Selected.SASUnits), SAS_Unit = drpSortByUnit.Selected.SASUnits))),User().Email);

Notify(

"Export process started. You'll receive an email once completed.",

NotificationType.Success, 3000);

I am getting the error that says: Invalid argument type (Table). Expecting a text value instead. "ExportFilteredTickets" flow is using the powerApps automate.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

developingteal 392 on at

Like
a
(0)

Report
Copy link

Link copied!

I would suggest sending json over to power automate, and the processing the json table. I have a feeling the data you are sending over is just ending up in text, rather than a table, and it is hard to format/send data over and match up exactly how it should be. Json should make things easier.

Convert to json -> send table - > trigger flow

Was this reply helpful? Yes No
developingteal 392 on at

Like
a
(0)

Report
Copy link

Link copied!

What's the status of this/ what's the current error?

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey,

can u try this:

ExportFilteredTickets.Run( Filter( Tickets, And( Or( IsBlank(dpStartDate.SelectedDate), DateCreated >= dpStartDate.SelectedDate ), Or( IsBlank(dpEndDate.SelectedDate), DateCreated <= dpEndDate.SelectedDate ), Or( IsBlank(drpStatus.Selected.Status), Status = drpStatus.Selected.Status ), Or( IsBlank(drpSortByUnit.Selected.SASUnits), SAS_Unit = drpSortByUnit.Selected.SASUnits ) ) ), User().Email ); Notify( "Export process started. You'll receive an email once completed.", NotificationType.Success, 3000 );

If the Post help you solve your issue, please mark it as verified answer and give it a like so we can help other in the community with similar issues

Greetings

Was this reply helpful? Yes No