Unanswered

Create HTML table from Filter array output: The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'.

(0) Share

Report

Posted on by suman_sa

Trying to filter all items that confirm to specific criteria using OData query in Get Items. And then further filtering it using a filter array (advanced options to club two filters here with or). Now I need to create an HTML table from th output and then send the entire HTML table as a summary in one email; also send out separate emails to every email mentioned within the html table. created the following but getting the error:

could someone advise, please?

BR,.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @suman_sa ,

I noticed that in the operation 'Create HTML table' you used 'current item', this dynamic content is an object, which is the cause of the error.

If you want to create an html table, I suggest you put 'Create HTML table' outside ‘Apply to each’, or use brackets to turn 'object' into 'array'.

I made a sample for you:

Create a list in sharepoint.

Create an HTML table outside of 'Apply to each'.

The output is all filtered data.

Use brackets outside the current item

Only the current item is output.

The above two methods are selected according to your actual needs.

Best Regards,

Wearsky

Was this reply helpful? Yes No
suman_sa 41 on at

Like (0)

Report

Thank you @v-xiaochen-msft for your suggestions.
1) am not adding that apply to each for the Create HTML table action. Once I add custom headers, PowerApps automatically add the Apply to each condition. (not sure how to get rid of this) - my attempt is to directly add the Create HTML table step after the Filter array. and then do a bifurcation(?) - need to send a a summary email (with all items from the html table) to an admin account and then individual email with each item to each email address in the body of the HTML table. Does this help you provide any more suggestions, please?

BR
SS

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (1)

Report

Hi @suman_sa ,

You can try using two 'Create HTML table' and 'Send an email' actions.

I made a sample for you.

Create a list, ‘Text’ is a text type column and ‘Person’ is a person type column.

Create list.

In the next step of the filter operation, create an HTML table. Value in customization uses expression.

item()?[‘column’]

Once created, send to the admin account.

The same operation is put into 'Apply to each'. Items are sent to each email.

Save and run flow.

The admin account receives a message that contains all items.

Other emails receive their respective items.

Best Regards,

Wearsky

Was this reply helpful? Yes No
suman_sa 41 on at

Like (0)

Report

Thank you, However, when I try creating the first html table after filter, powerapps applies a condition/two there.. I am not sure how to get rid of these.

Was this reply helpful? Yes No