Get specifc table content and sheet name from excel file

Like (0) Share

Report

Posted on 28 Apr 2024 14:12:45 by skai

I am not very familiar with power automate and I am struggling with this. I would like to get data from an excel file stored in sharepoint which is updated every few days (new sheets are added from a blank sheet which has various tables). Here is a what i want to accomplish:

check File A if sheets have tablex
if yes, get sheetname and get specific cells of tablex, lets say A5 and B5 (if possible)
check File B, tabley, if sheetname and cells from previous steps arent present, add them
if sheetname and cells from previous steps are present, update the column that holds B5

any help would be appreciated, i am not very familiar with power automate