Hi @am02
I have prepared a demo flow for your usecase.
See below, this is an excel file prepared for test purposes:
Now see the below flow:
I am designing a manually trigger flow scenario
Step 1: List rows present in table
Step 2: Use filter array action to filter rows by condition :
DaysOnsite>25 and less than 1000 and pickupdate is blank/empty
Expression used: and(and(greater(int(item()?['DaysOnSite']), 25), less(int(item()?['DaysOnSite']), 1000)), equals(empty(item()?['PickUpDate']), true))
This will give us filtered rows satisfying the condition.
Step 3: Use send http request to create a blank excel file
HTTP Request : _api/web/GetFolderByServerRelativeUrl('Shared%20Documents/Folder1')/Files/add(url='FinalOutputs.xlsx',overwrite=true)
Here Shared%20Documents/Folder1 represents the folderpath where the fileshould be created and FinalOutputs.xlsx should be the filename
Step 4: use create table to create the table in newly created excel file
Expression used above to reference the file: body('Send_an_HTTP_request_to_SharePoint')?['d']?['UniqueId']
Step 5: use apply to each to loop through each row of filtered action:
(Step 5.1 and 5.2 are inside the loop)
Step 5.1 : use compose action to create a JSON object having details of single which is to be added in excel file like below:
Written expression within compose action like this:
{
"Order": @{items('Apply_to_each')?['Order']},
"Name": @{items('Apply_to_each')?['Name']},
"Phone": @{items('Apply_to_each')?['Phone']},
"Article": @{items('Apply_to_each')?['Article']},
"Email": @{items('Apply_to_each')?['Email']},
"Delivery": @{items('Apply_to_each')?['Delivery']},
"LOCATION": @{items('Apply_to_each')?['LOCATION']},
"EMAILED": @{items('Apply_to_each')?['EMAILED']},
"ArrivalDate": @{items('Apply_to_each')?['ArrivalDate']},
"Arrived": @{items('Apply_to_each')?['Arrived']},
"DaysOnSite": @{items('Apply_to_each')?['DaysOnSite']},
"PickUpDate": @{items('Apply_to_each')?['PickUpDate']},
"PickUpTime": @{items('Apply_to_each')?['PickUpTime']},
"Employee": @{items('Apply_to_each')?['Employee']},
"Notes": @{items('Apply_to_each')?['Notes']},
"Column1": @{items('Apply_to_each')?['Column1']}
}
Step 5.2: use add row to table to add row to table like below
File: body('Send_an_HTTP_request_to_SharePoint')?['d']?['UniqueId']
Table: string(outputs('Create_table')?['body/name'])
Row:
Outside the loop use delay action so to keep rows updated in the file (keep delay for one min)
Use get file content using path to get the content of updated file:
Expression used: concat('Shared Documents/Folder1/FinalOutputs.xlsx')
In your case specify the file path where the file is stored of above path as shown above
Now use send email action to send the excel file as attachment like below:
Output of the process:
File created :
Email send:
Hope it helps !
