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