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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / for each new excel fil...
Power Automate
Unanswered

for each new excel file added, perform tests and update if necessary.

(0) ShareShare
ReportReport
Posted on by 7

Hello everyone, I need your help!

 

I have a folder on share point which contains several subfolders. Each of them contains excel files that have the same table with the same structure and the same column names (column A and column B).

 

I would like to design a flow that I would like to trigger as follows : Each time an Excel file is added to the folder or one of the subfolders I would like the Microsoft power automate flow to be triggered.

 

Subsequently, I have to perform a check on column B and update the line if necessary (if it contains a space, then I delete it (example "1234  567" by "1234567"). Subsequently I have other tests to perform. I started by adding the steps below :

 

Flow exemple.png

 

It's easily doable if I connect my flow to an excel file, the latter automatically retrieves the columns. But, in my specific case, for each added excel file that will trigger my flow, how to make column B appear in the update step so that I can test and update it if necessary?

 

Thank you for your help 🙂 !

Categories:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at
    Re: for each new excel file added, perform tests and update if necessary.

    Hi @Sofiane 

    Sorry, but I don't get your point 😅 What is the problem with column B? I mean, you can access its value using:

    items('apply_to_each')?['ColumnB']

    Could you provide more detail?

    Hope that helps!

    Ferran

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard