Answered

Add Columns to a excel spreadsheet

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I want to make an excel workbook that modifyies the columns beside on data that I send it from powerapps. For example runningSpeed:0, do not add a column called runningSpeed, if it was 1 then add a column called runningSpeed. Powerapps will send flow a list of constants that are zero or one, then flow will copy an excel template then flow will change that copy to show constants that had values of one. After flow had finshed modiying that copy of the workbook, flow would send it to a sharepoint site.

This is a cool logically way of going around not having the option to delete columns from an excel workbook if they were blank (or zero in my case).

Please Help,

AskingQuestions

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Adding Columns to a excel spreadsheet that you mentioned is not supported in microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

SCTdan 604 on at

Like (0)

Report
Copy link

Link copied!

As mentioned above, not something you can do in flow natively. You can do it via Graph API though https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Was this reply helpful? Yes No