Export filtered data from Gallery and convert it csv file and send via email

(0) Share

Report

Posted on by vrevankar

@BCBuized/ Community

Good Day,

I am working on an internal project where I have built a power app to track the Tasks for a project. I need to export the filtered gallery data to MS flow via the power apps trigger, wherein I watched several videos but was not able to achieve this as it threw an error I also tried to find posts in the community that do not meet the actual requirement . Kindly please help in achieving this

Below is the code used on the button which creates a collection named FilteredCollection from the Gallery which has to be triggered to Flow.

ClearCollect(

FilteredCollection,

Filter(

'PMIT TRACKER OMC AUT',

IsBlank(ComboBoxAIGroup.SelectedItems.Value) || IsEmpty(ComboBoxAIGroup.SelectedItems.Value) || 'AI Group'.Value = ComboBoxAIGroup.Selected.Value,

IsBlank(ComboBoxTaskStatus.SelectedItems.Value) || IsEmpty(ComboBoxTaskStatus.SelectedItems.Value) || 'Task Status'.Value = ComboBoxTaskStatus.Selected.Value,

'Target Date' >= DPFrom.SelectedDate && 'Target Date' <= DPTo.SelectedDate

)

);

I have followed Reza's video on the web and created the flow as below with Get Items (SP)

Not sure the Odata query used in the filter query is up to the mark also

again on the same select button tried with the following code to trigger the flow which is not working

PMITex.Run(field_3 eq ComboBoxAIGroup.Selected.Value,field_10 eq ComboBoxTaskStatus.Selected.Value, Text(DateFrom_1.SelectedDate,"yyyy-mm-dd"), Text(DateTo_1.SelectedDate,"yyyy-mm-dd"), User().Email);

Kindly request that someone help with this

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (4)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vrevankar ,

Please try below formula on the Button:

PMITex.Run(ComboBoxAIGroup.Selected.Value,ComboBoxTaskStatus.Selected.Value, Text(DateFrom_1.SelectedDate,"yyyy-mm-dd"), Text(DateTo_1.SelectedDate,"yyyy-mm-dd"), User().Email);

Best regards,

Was this reply helpful? Yes No
vrevankar 94 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni Thank you so much for the quick response sir the code works fine and the flow ran successfully but I'm receiving emails with blank data as below can you suggest what could have gone wrong

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vrevankar ,

In run history of the flow, please check if Get items action has returned expected result. If the result is blank, then the query may still have some mistakes.

I see you have a Query in PowerApps trigger, but it's not used in Filter query, what's it for?

Best regards,

Was this reply helpful? Yes No
vrevankar 94 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni I checked the Get Items Inputs which has fed the correct input as below
{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "GetItems"
    },
    "parameters": {
        "dataset": "https://dxcportal.sharepoint.com/sites/AMSOMC",
        "table": "f6071e2d-1d89-419c-b051-f55a6889f76c",
        "$filter": "(field_3 eq 'HPI') and (field_10 eq' Open ') and (field_1 ge'2023-08-01' ) and (field_1 le'2023-08-31')",
        "$top": 5000
    }
}
but the output is showing blank as below
export button has current code used
ClearCollect(
FilteredCollection,
Filter(
'PMIT TRACKER OMC AUT',
IsBlank(ComboBoxTaskStatus.SelectedItems.Value) || IsEmpty(ComboBoxTaskStatus.SelectedItems.Value) || 'Task Status'.Value = ComboBoxTaskStatus.Selected.Value,
'Target Date' >= DPFrom.SelectedDate && 'Target Date' <= DPTo.SelectedDate
)
);
PMITex.Run(ComboBoxAIGroup.Selected.Value,ComboBoxTaskStatus.Selected.Value, Text(DPFrom.SelectedDate,"yyyy-mm-dd"), Text(DPTo.SelectedDate,"yyyy-mm-dd"), User().Email);
which filters the data on the gallery and sends the collection to flow

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @vrevankar ,

Based on my test, you need to remove the spaces inside single quates beside Query2.

"(field_3 eq 'HPI') and (field_10 eq 'Open') and (field_1 ge '2023-08-01') and (field_1 le '2023-08-31')"

Best regards,

Was this reply helpful? Yes No
Verified answer

vrevankar 94 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni Kudos sir that worked appreciate your help here 🙂

Was this reply helpful? Yes No