web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email Datatable result...
Power Automate
Answered

Email Datatable results after filtering with Json

(0) ShareShare
ReportReport
Posted on by 233

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.

Chrisguff12_0-1620780404150.png

 

Here is my flow 

Chrisguff12_1-1620780688205.png

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, 

Categories:
I have the same question (0)
  • Verified answer
    JisungHan Profile Picture
    on at

    Hi @Chrisguff12 ,

     

    Here is a good article to make the process: https://www.netwoven.com/2020/02/25/bulk-insert-data-into-a-sharepoint-list-from-powerapps-gallery-control/

     

    The items should be in a Collection rather than a single variable. After that, it can be sent to Power automate with the expression: 

    JSON( yourCollection, JSONFormat.IgnoreBinaryData)

     

    Hope this helps. Thanks!

     

    Best regards,
    Jisung Han

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2026 Season 1

#1
trice602 Profile Picture

trice602 339 Super User 2026 Season 1

#3
David_MA Profile Picture

David_MA 270 Super User 2026 Season 1

Last 30 days Overall leaderboard