cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add Data into new excel column

1. I have a flow that adds a column to an excel, but the issue is that I can not import data to the new column right after is made when the flow is running. The data will come from a collection from PowerApps. I have the flow configuration down below. I think this is possible because Powerapps id is generated right after that column is made. How would I do thisScreen Shot 2019-08-14 at 5.45.15 PM.pngScreen Shot 2019-08-14 at 5.45.29 PM.png

 

 

Thanks,

AskingQuestions

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous 

 

Currently there is a known issue with the excel connector that is you cannot dynamically reference to a File or a Table on the excel connectors. 

 

This means that you cannot reference to files via variables or from previous actions (even the ones through which you are creating the excel file in the flow) and you will have to select the file by clicking the folder icon on the action and navigating to the file location and select the file from there. Only then it will allow you to choose the tables from the dropdown. (entering a custom value for the table won't work either as it is referenced through the GUID of the table). 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

1 REPLY 1

Hi @Anonymous 

 

Currently there is a known issue with the excel connector that is you cannot dynamically reference to a File or a Table on the excel connectors. 

 

This means that you cannot reference to files via variables or from previous actions (even the ones through which you are creating the excel file in the flow) and you will have to select the file by clicking the folder icon on the action and navigating to the file location and select the file from there. Only then it will allow you to choose the tables from the dropdown. (entering a custom value for the table won't work either as it is referenced through the GUID of the table). 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,847)