web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Read specific cell in ...

Power Automate

Answered

Read specific cell in Excel

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation