How to remove or delete columns of CSV exported by power apps

(1) Share

Report

Posted on by Huahua1217

I want to export a collection in power apps by power automate. This is the button code:

Set(
    varJSONVisibleDVtest,
    JSON(
        ShowColumns(
            VisibleDVtest,
            '试验项目',
            '试验标准/方法',
            '2WM Inner',
            '2WM Outer',
            '2WM H-Frame',
            '4WM Inner',
            '4WM Outer',
            '4WM H-Frame',
        ),
        JSONFormat.IndentFour
    )
);
Set(varCSVFile,ExportAcquisitionfile.Run(varJSONVisibleDVtest));
Then I use power automate to export a CSV file. 
But some of the columns('2WM Inner','2WM Outer','2WM H-Frame','4WM Inner','4WM Outer','4WM H-Frame')are blank I didn't input any value in app, so when I export the file I want to remove or delete the blank column.
How can I do this?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Could you try this in Power Apps?

With( { fvar_DVTest: ShowColumns( VisibleDVtest, '试验项目', '试验标准/方法', '2WM Inner', '2WM Outer', '2WM H-Frame', '4WM Inner', '4WM Outer', '4WM H-Frame', ) }, Set( varJSONVisibleDVtest, JSON( Filter( fvar_DVTest, And( !IsBlank('2WM Inner'), !IsBlank('2WM Outer'), !IsBlank('2WM H-Frame'), !IsBlank('4WM Inner'), !IsBlank('4WM Outer'), !IsBlank('4WM H-Frame') ) ), JSONFormat.IndentFour ) ) );

Was this reply helpful? Yes No