You’re offline. This is a read only version of the page.
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 :
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 🙂 !
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:
Share
Report
All responses (
Answers (
items('apply_to_each')?['ColumnB']Could you provide more detail?
Hope that helps!
Ferran
