HI,
Here is a step by step guide to do this. If you follow this and have questions let me know.
Question:
* What is the interval that you need this to happen??
Since I don't know I am going to generate a Triggered Manual Flow
Pre-Information before flow.
1. Your Excel Data must have an Excel Table around it. You have 2 options. You can put the Table in before , or you can do use the Create Table actions in Power Automate to create it. This isn't something I can decide for you, so I am going to simply give you ... option(s) in the steps below
2. You will need the file path and table name (if you predefine it) so youll need to have that information either hard coded, or in an Environment Variable or in a SharePoint List, or Flat File. Somewhere you can get it at run time
Flow steps
1. Create a new cloud Manual Flow (You can switch the trigger later)
2a. If your Excel does NOT have a table in it, You need to add a Create Table (excel step), you will need to know the Sheet, the Columns etc for this action
2b. If your Excel has a Table in it its easier so do nothing to in this step
3. Add a List Rows in Table for Excel Action
This will return back data based on the File, Table you tell it
4. Add a Condition Action
In the Left side put length(DynamicBody/ValueOutputfromStep3) , where length() is an expression. So when you click in the left side it popups up the
dynamic window. Tab 1 is dynamic properties, Tab 2 is the Exrpressions
Click Expression tab first, type length() thats ( ) with no space
Not click tot he Dynamic Property Tab and click inside the() and scroll till you get the Output dynamic property of step 3
in the middle put greater than
on the right put 0
5. in the Yes side of the Action
This is where you will iterate through your rows and do updates
Add an Update row in a table for eXcel
In the Loop, each loop is the Row you are on
Here you can either have a Single Compose Action that will be used to generate the String you want in Column 3
Or
You can adad a Switch, and have the input be column 2
Then in 3 different paths, each path could either have an update action where you hard code the value for column 3 based on the Switch Check
or you can set a Compose etc
Now add an Update Row in Table for excel, specify the Key for the row
And done.
90
Share
Report
All responses (
Answers (
