Thursday, July 25, 2024

Power Automate + Excel data

  • Extract excel data, get manager and update row with user details which will get from GET MANAGER

  • Concepts and examples

    • Key column: Column in a table that will be use to search a value (key value).
    • Key value: Value in the key column that will be used to identify a specific row.

    The following table is an example. To perform a row operation in the second row of the table, the key column should be Column 1 and key value should be 200.

    Column 1Column 2Column 3
    100A-2A-3
    200B-2B-3
    300C-2C-3

  • Flow screenshot for reference

Excel Online (Business) connector lets you work with Excel files in document libraries supported by Microsoft Graph (OneDrive for Business, SharePoint Sites, and Office 365 Groups).
https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/

Excel Online (OneDrive) connection provider lets you work with Excel files stored in OneDrive. This connection provider only supports personal (MSA) accounts.
https://learn.microsoft.com/en-us/connectors/excelonline/

Power Automate + Excel data

Extract excel data, get manager and update row with user details which will get from GET MANAGER Concepts and examples Key column:  Column i...