Collection in Export to Excel JSON

(0) Share

Report

Posted on by RJF61

1,265

I have the following in the OnSelect for a Save button.

Patch(
EmployeeShort,
varFormData,
frmEEInfoEntry.Updates,
frmHiringRequest.Updates
);
ClearCollect(
colEmployee,
varFormData,
ShowColumns(
EmployeeShort,
"HRF_Pos_Dept",
"HRF_Pos_HiringMgr",
"HRF_Pos_SeniorLdr",
"HRF_Pos_JobTitle",
"HRF_Pos_NoPosFill",
"HRF_Pos_BkFillSep",
"HRF_Pos_Justification"
)
)

I then have the following on another button...

ExporttoExcel.Run(
JSON(
colEmployee,
JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes
)
)

For the ExporttoExcel.Run, I am receiving ALL columns and not the collection 'colEmployee'. How can I limit the columns to the colEmployee collection that does work in the OnSelect above?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

You could always just send all columns and use a Compose statement in the flow itself to limit the columns to what you need. Here is an image of my compose that essentially eliminates all the other columns from SP that I dont want to have to deal with or display in my excel sheet/email etc.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmollet Thanks for the response. So in my case, I assume the Compose would be place between the Create CSV and Create File. Regardless, one of my issues is that the Dynamic Values are not shown when I review per the bottom pic. Is this a difference in running the Flow from Power App?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

I actually have never ran flow from power apps I just launch it in the browser to keep things separate and on diff screens. Mine is inside of a loop so what I do is use the current items properties like so:
Item()?[‘FieldName’]
or if you have multiple loops
item(‘Apply_to_each2’)?[‘FieldName’]

Was this reply helpful? Yes No