Forum Discussion
Helper IIPower Automate visual/action export to file is removing columns
Hi Bi2thelly
Yeah, that is by design because columns that do not have any data typically are hidden or the data is not shown in the way that power FBI works. So what you have done above looks to be correct. And the reason for it taking longer is it's going to bring in all the rows that have no data.
Helper IISo it appears that if that column is completly blank, the compose operation will not bring in the column. If you need the column to stay you have to input your array manually in the compose operation. Not sure if the below is the most efficient. In fact it seems to take about 10 secs longer to run, but it worked and kept all the needed columns.
{
"Notification": @{items('Apply_to_each')?['NOTI_ID']},
"NotiType": @{items('Apply_to_each')?['NOTI_TYPE_ID']},
"Material_SN": @{items('Apply_to_each')?['Material_SN']},
"Country": @{items('Apply_to_each')?['NOTI_COUNTRY_ID']},
"MediumText": @{items('Apply_to_each')?['NOTI_MEDIUM_TEXT']},
"NotiStartDT": @{items('Apply_to_each')?['NOTI_START_DT']},
"NotiCompletedDT": @{items('Apply_to_each')?['NOTI_COMPLETED_DT']},
"DownTimeEndDT": @{items('Apply_to_each')?['NOTI_DOWNTIME_END_DT']},
"SiteVisits": @{items('Apply_to_each')?['SV_FINAL']},
"Has_Parts": @{items('Apply_to_each')?['HAS_PARTS']},
"Effort_ActDT": @{items('Apply_to_each')?['Actual Effort ActDT']},
"LongText": @{items('Apply_to_each')?['LONG_TEXT']}
}