Answered

List rows present in a table not displaying the rows when connecting to xlsm file using 'Get file metadata'.

(0) Share

Report

Posted on by DamienTonks

Hi,

I am trying to connect to an XLSM file in sharepoint and list the rows in order to send email notifications based on cell content.

I have used the 'Get file metadata' module to pull the folder and then the 'Get Tables' module to pull the correct table from that folder.

I can the 'List rows present in the table'. However, when using the select function it does not show the discreet rows. It only shows 'values' and body as highlighted.

Does anyone know how I can have the rows listed as dynamic content so I can use them in creating html tables and sending emails?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

In the Data Select the From should be set to value. Then when you click into the Enter Value field in the map line you should see the individual columns. The From requires an array, that's why you aren't seeing the columns at that point.

Was this reply helpful? Yes No
DamienTonks 7 on at

Like (0)

Report

Hi,

Thanks for your reply.

I have added the from as value but still the individual columns are not listed.

Any other suggestions. I am not sure I have configured the rest of the flow properly. However, when testing the flow I can see that it is pulling the correct table and data in the 'list rows present in a table' output.

Many Thanks,

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

The other option would be to use a Parse JSON to identify the individual columns in the list of rows. That shouldn't be necessary, but should work.

Was this reply helpful? Yes No
DamienTonks 7 on at

Like (0)

Report

Hi Paul,

Managed to get this working today using the Parse JSON.

Thanks!

Was this reply helpful? Yes No