Power Platform Community Forum Thread Details

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

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 🙂 !

Quick Links