web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add or update data in ...
Power Automate
Unanswered

Add or update data in a created file in the same flow - ERROR

(0) ShareShare
ReportReport
Posted on by 12

Hello,

 

I´ve a problem while trying to add or update contents in a file created by conditions on the same flow, summarizing:

 

-A trigger (Mail arrives) starts.

 

-Mail content is parsed.

 

-Parsed outputs are stored.

 

-A condition by "name is equal to" checks if a file (.xlsx) exists in a Sharepoint library and resolves true or false.

 

-True: Do nothing.

 

-False: Create a file with a defined name and populate it with stored outputs.

 

Here is when issues starts,I´m not able to find a way to create a file and add content on the just created file, because for PA it doesn't exist yet in spite the file is successfully created (verified with a previous condition step "Sharepoint Get files (Properties only)" and validated as true.

 

IsaacFC_1-1668675636156.png

All the Excel Online (Business) actions like "Update a row","Run script","Create table" etc...needs and existent file.

 

IsaacFC_0-1668674331166.png

 

I tried a lot of options to add in "File" like make conditions nested on the same condition to validate and passed on it, expressions like contains etc...but the message is always the same:

 

IsaacFC_2-1668676253412.png

 

 

Any suggestions on this,please? 

 

Many thanks.

 

 

Categories:
  • okeks Profile Picture
    802 Super User 2024 Season 1 on at

    The easiest way might be to have an empty Excel file which you copy to the right place with right name and to the changes on that file.

  • IsaacFC Profile Picture
    12 on at

    Hi @okeks ,

    Yes,I know, that's the first option,but the goal of this is avoiding having a highly populated unique file because the trigger is expected to run a lot of times per day during one month or so.

     

    Thanks for your reply anyway.

     

     

     

     

  • okeks Profile Picture
    802 Super User 2024 Season 1 on at

    I don't mean to write all your runs to the same file but to copy a empty file and write into the copy.

    That has the same effect as creating a new file from scratch every run.

  • IsaacFC Profile Picture
    12 on at

    Hi okeks,

     

    Well...is another approach, but it doesn't solve the issue because if I try to call the copied file (created in the same flow) the problem is the same. Looking for solutions, I found something related with the "Tracked properties" option,but I´m not able to do anything if I set it in the loop.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard