cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TrucoBen123
Frequent Visitor

How to remove iteminternal id and odata.etag columns

Hi all, I am trying to extract data from an excel file and display it in an email where there is a specific value that has been met. However, it has been giving me this extra 2 columns while displaying the html table. Any headway to this?

 

TrucoBen123_0-1637648279789.png

 

MY FLOW:

TrucoBen123_1-1637648301680.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@TrucoBen123 ,

Use a select action after the filter array action, and in it create the output for HTML table, column name - value. 

gabibalaban_0-1637667105178.png

From -> body('Filter_array');

Map - > Key - Value. 

Also, Can you take in consideration to use ODATA filter inside "List rows present in a table" instead of bringing all values to flow and filter it locally ? (this is applied only if the filter condition is not to complex, as the Excel connector doesn't support many operations).

Of course, that in this case the From from the new select action will be

(use the Add dynamic content ->expressions):

body('List rows present in a table')['value']

 

Hope it helps !

 

View solution in original post

4 REPLIES 4
gabibalaban
Super User
Super User

@TrucoBen123 ,

Use a select action after the filter array action, and in it create the output for HTML table, column name - value. 

gabibalaban_0-1637667105178.png

From -> body('Filter_array');

Map - > Key - Value. 

Also, Can you take in consideration to use ODATA filter inside "List rows present in a table" instead of bringing all values to flow and filter it locally ? (this is applied only if the filter condition is not to complex, as the Excel connector doesn't support many operations).

Of course, that in this case the From from the new select action will be

(use the Add dynamic content ->expressions):

body('List rows present in a table')['value']

 

Hope it helps !

 

View solution in original post

What is the key and value for the map section?

 

TrucoBen123_0-1637800581119.png

 

@TrucoBen123 ,

key = the desired name of the column in the resulted array of objects,

value = item()?[‘name_the_column_from_Excel’]

Ok Thanks

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (3,245)