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
yashag2255
Dual Super User II
Dual Super User II

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
yashag2255
Dual Super User II
Dual Super User II

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (2,134)