Unanswered

Read specific cell in Excel

(0) Share

Report

Posted on by wemdens

Hello community,

Unfortunately, I can't solve the following problem with PowerAutomate:

I would like to read a specific cell with a single number from an Excel spreadsheet and then proceed with a condition based on that value:

If the value is greater than 0, it should be reduced by 1 and certain actions should be continued. If the value is 0, it should stay at 0 and something else should happen.

Could someone give me a hint how to do this in detail?

According to my understanding:

List Columns

Apply Filter Array to get the single value from the single cell (how exactly does the Filter Array command need to be to identify the single cell?).

Then a condition based on the FilterArray output?

About Help I would be happy!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

So this is a single cell that you need to change? Like, for example, you want to get data from Excel in cell C3 or E6 or something like that? Not a value within a table, in a row?

I don't think you'll be able to do this with the Excel actions in Power Automate. If you have a license, you could use Power Automate Desktop which has a different set of Excel actions, that WILL be able to collect data from a specific cell.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @wemdens ,

If you didn't create a table in excel and you had the license to use excel script, I made a sample for you.

function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Set range B3 on selectedSheet let tempVar = selectedSheet.getRange("B3").getValue(); let tempVar2: number = tempVar as number; if(tempVar2 > 0) { selectedSheet.getRange("B3").setValue(tempVar2 - 1); return tempVar2 } else { return 0 } }

Best Regards,

Wearsky

Was this reply helpful? Yes No