Unanswered

How to recover cells value on excel

(0) Share

Report

Posted on by ProtoSup

Hi everyone, How can I make a flow recovering cell content ?

Please, see my two screenshots for ilustrate my question.

Here is my entry data, a table with 2 columns ans 3 rows ans a cell with a table ID in "E2" with yellow highlight

how can i create line with thoses values in this list ? :

The title colums must contain the "E2" yellow field and juste the Z item have quantity to inform in the list.

Thanks in advance for all your advices.
I'm ready to give you kudos !!

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

Sort by

v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ProtoSup,
Do you want to get cell value to populate the column in SharePoint list?
You can use the Run Script action.
function main( workbook: ExcelScript.Workbook, sheetName: string, cellAddress: string ) { let sheet = workbook.getWorksheet(sheetName); let cellValue = sheet.getRange(cellAddress).getValue(); return cellValue; }
And you can use the same method to get other cell's value and populate in list.

Best Regards,
Kyrie

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-mingkz-msft , I just realized, my excel file was not in table format, I can't use theses scripts blocks. Have another advice ? possible to have cell data with cordinates ? I most to recover few cell values, i can put coordinates directly in the script, no problem...

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@ProtoSup,
Running scripts does not require a table format. Please try.

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

ok i'll try and let you know, thanks for the help @v-mingkz-msft

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mingkz-msft , how to adapt this script to search multiples cels ? fors 3 differents cells for exemple ? It's not optimal to duplicate 3 times the action bloc ...

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mingkz-msft , I have another problem, the 'Run script' bloc can't find my file while the 'Get File content using path' find the file... How can i fix this error by add the direct or dynamic url to the file ?

Thanks

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@ProtoSup,
You can try to copy the file path from get file content and paste to run script.

Best Regards,
Kyrie

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mingkz-msft Another problem with the run script bloc :

Thanks again

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@ProtoSup
Could you please show the screenshots about your run script action in edit mode?

Was this reply helpful? Yes No
ProtoSup on at

Like
a
(0)

Report
Copy link

Link copied!

yes, it's my flow : @v-mingkz-msft

Was this reply helpful? Yes No