Forum Discussion
Helper IIPower Automate visual/action export to file is removing columns
Hello,
I'm running the Power Automate visual in my report to export to Excel (CSV) detailed information about the currently filtered information on the report page. When I initially setup the Power Automate visual I add all the columns that I need to the visual Build pane. I edit the visual and go into the Power Automate setup. I create all the steps which works fine. However, when I finally click the button in my report, one of the columns is missing. I've set this visual up over and over again. It is not always the same column. Is there any way to fix this?
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.
4 Replies
- GilbertQ
Super User
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.
Bi2thellyIt when I look at the logs for the successful runs, it does appear that the Compose operation does not contain all the columns.
- Bi2thelly
So 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']}
}
