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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No