Power Platform Community Forum Thread Details

Email Datatable results after filtering with Json

Hello,

Not sure if this is the right forum for my issue. Please let me know. Also I have just started using Flows and don't have have a lot of knowledge yet.

I am trying to make a flow that will send an email with the current data that has been filtered. I have used the same steps on another app by I cant get this one to work and keep getting an error on the button. I'm also not able to run the flow from the Flows Menu.

I'm not sure if my issue is with the Schema, or on my last app I used Switch and on this one I used Sort and Filter.

Here is the OnSelect Property of the button.

Here is my flow

Here is the Full Schema

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "Title": {
 "type": "string"
 },
 "RequestedID": {
 "type": "string"
 },
 "DateRequested": {
 "type": "string"
 },
 "YearRequested": {
 "type": "string"
 },
 "Description": {
 "type": "string"
 },
 "RequestedBy": {
 "type": "string"
 },
 "ItemStatus": {
 "type": "string"
 },
 "CommonSupplies": {
 "type": "string"
 },
 "Category": {
 "type": "string"
 },
 "Cost": {
 "type": "string"
 },
 "Quantity": {
 "type": "string"
 },
 "TotalCost": {
 "type": "string"
 },
 "PartNumber": {
 "type": "string"
 },
 "Suppliers": {
 "type": "string"
 },
 "ConfigsArea": {
 "type": "string"
 },
 "Facility": {
 "type": "string"
 },
 "ApproverName": {
 "type": "string"
 },
 "Notes": {
 "type": "string"
 },
 "ItemLink": {
 "type": "string"
 },
 "TechName": {
 "type": "string"
 }
 },
 "required": [
 "RequestedID",
 "Description",
 "RequestedBy",
 "ItemStatus",
 "CommonSupplies",
 "Category",
 "Cost",
 "Quantity",
 "TotalCost",
 "PartNumber",
 "Suppliers",
 "ConfigsArea",
 "Facility",
 "ApproverName",
 "Notes",
 "ItemLink",
 "TechName",
 "DateRequested",
 "YearRequested"
 ]
 }
}

Thanks,

Quick Links

Leaderboard