cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
S_J_G
Helper II
Helper II

How do you refer to a file you just created in the same flow?

Dear fellow Users,

 

I have a question regarding using Excel template's. The flow i am trying te create;

Get Fileconent (my excel template) >> Create file (copy of template+current date) >> fill table whit data in newly created Excel file.

 

Copying the file and renaming/filling in table whit data is not the problem. i have created two separate flows that prove this principle. Only I can't successfully combine the 2. How do you refer to a file you just created in the same flow?

 

Some examples would be very helpfull.

 

*PS; i just started using flow, excuse my noob question. 😅

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @S_J_G,

 

Maybe we can do it the other way around instead of copy file firstly.

 

There is a template you have already created, you could following these steps:

fill table whit data in Excel template>>Get Fileconent (your excel template)>>Create file (copy of template+current date) >>empty template file (List rows in a table + Apply to each + delete a row)

Annotation 2020-04-07 133037.png

 

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

View solution in original post

Hi @S_J_G,

 

Use the Create file action instead of Copy file action, it allows you to name the file dynamically, the steps are:

fill table whit data in Excel template>>Get Fileconent (your excel template)>>Create file (copy of template+current date) >>empty template file (List rows in a table + Apply to each + delete a row)

 

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

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

@S_J_G  When you create a file it outputs an 'itemID' which you can then use to get the file properties on contents from the same flow. See the example below with SharePoint:

 

2020-04-06_1337.png

@Anonymous thank you for your fast reply!

Could you be more specific? i added a screenshot of my current flow.

I can't select a table. or do i need a custom values? 
image.png

 

Anonymous
Not applicable

@S_J_G  You can't use the table dropdown when the file itself is dynamic because the flow doesn't know which file to look in. Instead you need to use the option to enter a custom value and manually enter the name of the table. Alternatively you can use a dynamic content item in the custom value if its not fixed. 

Jcook
Most Valuable Professional
Most Valuable Professional

Hello @S_J_G

Unfortunately you cannot use a dynamic file name in excel connector. Their is a workaround which you can follow in this blog:
http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





@Jcook ty for your replay.

To be honest, this is way above my skill level....

I broadly understand what they are doing. but i am already stuck the HTTP request.

If you want to help me you really have to explain it step by step, but I understand that this takes too much time.

So I probably have to try something else get the same result. or just manually copy/rename my excel files.

 

I am gonna leave this post unresolved, because i really dont know for sure.

Maybe someone else will find this conversation useful. 

 

Ty for your time @Jcook /@Anonymous 

#Nooblife#GetGood

 

 

 

 

Hi @S_J_G,

 

Maybe we can do it the other way around instead of copy file firstly.

 

There is a template you have already created, you could following these steps:

fill table whit data in Excel template>>Get Fileconent (your excel template)>>Create file (copy of template+current date) >>empty template file (List rows in a table + Apply to each + delete a row)

Annotation 2020-04-07 133037.png

 

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

Hello @v-litu-msft 

 

Thank you!  this is exactly what i need.

only one problem remains. renaming the copied fil. how do you formulate the custom input so that it always takes name + date.

 

Destination site input: folder/expression 'formatDateTime(utcNow(), 'yyyy-MM-dd')' does not work.

should i use custom input at "if another file is already there"? how would i formulate that?

 

image.png

Hi @S_J_G,

 

Use the Create file action instead of Copy file action, it allows you to name the file dynamically, the steps are:

fill table whit data in Excel template>>Get Fileconent (your excel template)>>Create file (copy of template+current date) >>empty template file (List rows in a table + Apply to each + delete a row)

 

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

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Week 1 Results for Summer of Solutions Challenge

It has been an exciting week in the Power Users Communities.  The Summer Challenge is off to a great start!   Check out the Top 5 Members and Top 5 Super Users in each of the communities.  Each of the following users will receive an entry for each Authored Solution that they provided within 24 hours of a forum question during Week 1 August 8-14.   Who will be our Week 2 Top Entries? Check out more information on the Summer of Solutions Challenge in the News & Announcements: Power Apps, Power Automate, Power Virtual Agents, Power Pages.   Power Apps: Community MembersSuper Users@gcmfaizan@LaurensM @Devvj@WarrenBelz @happyume @madlad @MarioRing @timl @kent-culpepper @Amik    Power Automate: Community MembersSuper Users@trice602 @ManishSolanki @creativeopinion @wskinnermctc@SamLed @Agnius @rzaneti @SudeepGhatakNZ @kinuasa @abm    Power Virtual Agents: Community MembersSuper Users@fernandosilva @MattJimison (open)(open)(open)(open)(open)(open)(open)(open)   Power Pages: Community MembersSuper Users@Lucas001 @ragavanrajan @Fubar (open)@OOlashyn (open)@Inogic (open)(open)(open)   ** Tip: If you see an (open) spot these are great communities to participate in to earn entries for the challenge.

Community Challenge: Summer of Solutions 2023--Win a Pass to #MPPC23

  We are excited to announce the Summer of Solutions Challenge!  This challenge is open to all Power Platform (Power Apps, Power Automate, Power Virtual Agents & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities: Power Apps, Power Automate, Power Virtual Agents & Power Pages.   The top 10 participants (5 Community Users & 5 Super Users) every week will receive a badge on their profile for participating in the challenge.  (1 badge per person).    The challenge will last for 5 weeks. There will be a new leader board every week of the challenge. The leader board will recognize the top 10 participants (5 Community Users & 5 Super Users) for that week. Leader boards will be posted in the News & Announcements of each community. At the end of the challenge, each community will award the top community user and top Super User, for a total of 2 winners per community.     In addition, we’ll randomly draw 2 more winners from all entries for each week’s top 10 users. The Winners (10 in total) of the drawing will receive a complimentary pass to the Power Platform Conference in Las Vegas in October 3-5, 2023.      Please note: Prize is the complimentary pass to the Power Platform Conference ONLY. Airfare and lodging are not included. The pass has no monetary value and compensation is not available should the winner not use the pass.    Here is how it works:    When: There are 5 weekly challenges   Week 1: August 8-14 Week 2: August 15-21 Week 3: August 22-28Week 4: August 29-September 4 Week 5: September 5-11  How:   During the challenge, you earn an entry for every accepted solution you provide. Each solution counts towards one entry in the drawing. (i.e.: 5 solutions = 5 entries) Every week, the top 10 users (5 Community Users & 5 Super Users) for each community with the highest number of solutions will be entered into a random drawing.  The drawing will take place on September 15, 2023. We will announce the winners on the same day. The winners will have one week to accept or decline the prize.   You will need to provide an answer to the post so it can be marked as an accepted solution. The thread must be marked by the original poster of the question as an Accepted Solution within 24 hours of the original posting.  We highly recommend you @mention the author of the post, so they are notified of your comment or potential solution and can mark it as an accepted solution.  To help find solutions in the community, you can look at any board landing page that does not have a green check mark that appears to the right of the post.    You can find instructions for marking your response to your post as a solution in our support articles: Power Pages: Using the Community, Contributing to the Community  We hope you are as excited about the Summer of Solutions challenge as we are and can’t wait to see who will be able to find the highest number of solutions!   ---------------------------------------------------------------- Rules:   Challenge runs August 8th 12am PDT thru September 11th 12m PDT.  One pass per winner. Once your name has been randomly selected, you will not be eligible to win another pass. If your name is randomly selected a second time, an additional drawing will take place.  Winners will be notified on September 15th, via private message in the community. Once the user accepts, we will post in the News & Announcements of each of the communities.  The winner will have one week to accept or decline the prize.  If accepted tickets will be sent to the user If declined, a 2nd random drawing will be held. Prize only consists of a pass to the Power Platform Conference (air and hotel are not included) Please review the Rules attached to this post.   

Productivity Across Borders: Localized content now on Microsoft Release Planner

We are excited to announce that starting August 8th, 2023, Microsoft Release Planner supports the content in 11 new languages. Users around the world can now view the release plans of Dynamics 365 and Power Platform in Danish, Dutch, Finnish, French, German, Italian, Japanese, Norwegian, Portuguese (Brazilian), Spanish, Swedish, and English.   This update underscores our commitment to inclusivity. We at Microsoft strongly believe that language should not be a barrier to accessing tools and information. With this update, we aim to provide a more personalized, standardized, and intuitive user experience regardless of where you are in the world. How to view and manage plans in your preferred language? Our user-friendly design ensures that the Release Planner automatically loads in your preferred language based on your browser settings. Additionally, you can switch to your desired language through the language switcher in the header.  Your comments are displayed only to the stakeholders with whom you have shared the plan. The owner of the comment has complete control over editing and deleting the comment.   Customize your view by using multiple filters, sorting, and grouping criteria. These criteria are available for both All release plans and My release plans views. You can also view the plans grouped by product theme or timeline.   The Release Planner advantage  The Release planner for Microsoft Dynamics 365 and Microsoft Power Platform allows customers to view and manage release plans across all active release waves in a unified and interactive interface while giving them the option to personalize, filter, sort, and collaborate on release plans.    Under the hood, the Release Planner is powered by the Power Apps portal. It is created based on customer feedback to address the constraints of content suitability, discoverability, and personalization. Our goal is to improve the release planning and change management process where it matters most - help customers identify and track their salient capabilities, included in both the current and upcoming release waves.   Here are some of its key features:    Content personalization through ‘My Release plans’ Create a curated list of release plans you would like to follow. All the release plans across various products can be viewed in a unified view.   Collaborate on plans effortlessly and securely  Share your curated list and effortlessly and securely with your stakeholders. Collaborate on individual plans using notes and comments all within the Release Planner experience.   Thank you for your continued support as we work to make our product more accessible worldwide. We hope this update sparks more creativity and productivity across our global community! Stay tuned for more exciting updates. Here's to breaking down barriers and welcoming a world of new possibilities! 

Users online (4,044)