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)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you able to share a sample google worksheet?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

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