Power Platform Community Forum Thread Details

I would like to do the following in Power Automate's cloud flow, so please tell me the flow.

Excel is stored in the share point and is tabulated. The information in Excel is modified by function for each project, and the URL and email address of the Excel file are updated for each project No. and changed every time.

Cell A1 is written as "Project No", and A2 is written as 1, for example. B1 is written as "email address 1", B2 contains an email address, C1 is written as "email address 2", and C2 contains an email address D1 is described as "link", and D2 contains the URL of the Excel file.

I want to get email addresses 1 and 2 and assign the editor to the URL of the Excel file listed.

By retrieving file metadata by path, I'm trying to get the D1 link and get the URL, but it doesn't work. I don't know what other methods there are, so I would appreciate it if you could tell me.

Excel is tablized and is in this state. "No." And "Mail1", "Mail2" and "URL Link (Excel file)". I want to get the URL Link and grant access so that Mail1 and Mail2 can edit the file.