Answered

List Rows Present in a Table returns metadata with the row data

(0) Share

Report

Posted on by Samwise23

Hi,

I have the following flow that is triggered when a new email arrives, it creates an Excel file in a SharePoint location then creates a table in the file, then retrieves the table rows, and then posts the row data in Teams channel/group chat.

The flow works, BUT, now I have a problem with metadata, it seems like some JSON is included in the message sent to Teams channel.

Such as this:

{"@odata.etag":"","ItemInternalId":"e4fa9d6f-438b-49aa-bef9-bfb1d7ce253a","Column1":"row value","Column2":"row value","Column3":"row value"...etc!}

And I would like to get only:

Column1: row value, Column2: row value, Column3: row value,...etc!

Is that possible? How can I do that?

This is the current flow:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Samwise23

Pls use "Select" action to select particular properties from the json array. Pass the output value object of "List rows present in a table" action to the Select action as input. In map parameter, add the key or header and in value use the expression:

item()?['Column Name']

Pls replace actual column name in the above expression.

Add map entry for the required columns and then pass the output of select action in the "From" parameter of "Apply to each" action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Samwise23 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki ,

Thanks for your kind help.
It worked but I still have characters to get rid of, now it looks like this:

{"Column1":"row value","Column2":"row value"...etc!}

I would like to remove the curly braces and the double quotes as well to have the following (just comma separated):

Column1: row value, Column2: row value

Any ideas?

Was this reply helpful? Yes No
Verified answer

Samwise23 58 on at

Like (0)

Report
Copy link

Link copied!

Solution provided here:
https://powerusers.microsoft.com/t5/Building-Flows/SharePoint-Create-File-Action-File-Content-Value-Changing-After/m-p/2576191#M287709

Was this reply helpful? Yes No