How do I extract data from a cell in a Google sheet

(0) Share

Report

Posted on by Steve48

431

I have worked in Power Automate Desktop but not Power Automate (cloud) version. Ki am a newbie and don’t have an Excel Business account. I have used the Get Rows action to specify the files and a worksheet. I think I should use the Filter Array. Action to get the data I want but am unsure of how to populate the dialog. I want to get the value of row 2, column ´Path’, in other words cell B2.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Are you able to share a sample google worksheet?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Steve48 ,

I've made a test for your reference:

1\My Google Sheet

2\My Flow

outputs('Get_rows')?['body/value'][0]['Path']

Result

Best Regards,
Bof

Was this reply helpful? Yes No