------------------------------------------------------------------------------------------------------If my post helps you with your problem or answers your question, please mark it Solved or Answered. The main reason it takes longer is because that action uses variables inside it. Access to Power Automate. So, in this step, we targeted the date data present in the excel sheet because excel dates dont carry over the way we expect, so we will initialize variable per date column. I may mark this question as answered and open another question for the error above. If we increase the data in the excel file to say 20k rows then by using this method we get the required data in approximately 10 seconds! Save my name, email, and website in this browser for the next time I comment. hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution. This has been extremely helpful! Step 9: Create an item in a SharePoint list. Let's say I pass this query to be executed: let TestTable = datatable (ColumnName1:int, ComumnName2:string) [ 1, "some string value" ]; TestTable. How can I possibly suppress this error please? You can imagine the 'Key Column' as the left side of the filter, and the 'Key Value' as the right side. You'll use the Data Operation - Join action to change the comma delimiter (,) to a semicolon (;) by following these steps: Add a new action, search for Join, and then select Data Operation - Join. Microsoft Power Automate Community Forums Get Help with Power Automate Using Connectors Get table Dynamically Reply Topic Options WebDev New Member Get table Dynamically 06-30-2019 09:53 PM Hey, I have a flow currently set up to take in an email with an attatched excel (set template). I am a leader of the Houston Power Platform User Group and Power Automate community superuser. With this action, we can access Sharepoint using the SharePoint's API. Otherwise, you may set calculation mode for this workbook to. Comma-separated list of columns to retrieve (first 500 by default). The idea of this is: when any one of these sheets is modified/added, I need to take the 1-line table in the sub-sheet called . Hello rathnasiri, To list all the rows present in the excel table, we will create an action by clicking on the Next step. Lastly, the flow will append this information to the Excel sheet. It looks like this for informations sake. Which makes it a powerful option with low impact on performance and a low impact on your Power Platform . The different sections use different examples. The input value will overwrite the specified cells and columns left blank will not be updated. Use an output from the OneDrive for Business connector's triggers/actions (file's, Use an output from the SharePoint connector's triggers/actions (file's. With AI Builder form processing, you can automate the extraction of fields and tables from documents you work with every day, such as purchase orders, application forms, delivery orders, tax forms, and others. Create an Excel sheet for the Employee information, and make sure the excel file has a .xlsx extension. Table2. Similarly, choose the initialize variable action and then set the name to varDate2 and type String. These column/heading names can be stored in a list in SharePoint or any other place if needed so that there wouldnt be a need to edit the flow later. To create a Flow, Log in to Power automate, then click on create -> Scheduled Cloud Flow. replace(, , how to pick 1 table (multiple tables in compose like 1.. 10) I want to get 4th table data to extract. In the IssueType column, select var_other. This action has been deprecated. Take the whole email body, and split it by the