You’re offline. This is a read only version of the page.
167
i am trying to take an outlook attachment, upload it to onedrive, create two excel tables from that file. I need to filter out blank rows from those two tables and then send an email for each record. I get the error below when trying to iterate through each record.
@abm , see below. The two filter array actions are looking at data similar to below. I use the filter array actions to filter out blanks rows from two excel online tables. I basically need to email each record to the email field shown for that record.
| Pro Number | Date | Est Delivery Date | Origin | Destination | Terms | Balance | Responsible Account | Responsible Customer | Responsible Name | Participant Type | Responsible Risk Code | Responsible Analyst | |
| 24571467 | 2022-05-05 | 2022-05-06 | JAC | NAA | Prepaid | 394.64 | 1 | 100 | Cust1 | Shipper | CASH ONLY | John Doe | cust1@email.com |
| 24571466 | 2022-05-05 | 2022-05-06 | JAC | OCA | Prepaid | 328.76 | 2 | 200 | Cust2 | Shipper | CASH ONLY | Jane Doe | cust2@email.com |
Hi @amcneil32
Based on the parse json I have used a sample data something like below.
[
{
"Pro Number": "4444443",
"Origin":"CHR4"
},
{
"Pro Number": "4333",
"Origin":"CHR6"
}
]
Below is the Schema I generated
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
