Hi,
I'm trying to build a flow Originally to :
- Everyday
- Get item from a SP list
- Filter it ( on my calculated or choice column)
- create a new excel file from a template
- get some of my values in this excel file
- attach this file to an email
- send the email to one or more person, from another list
Mostly, using the following articles I'm managing it :
1./2. by previous experience & https://docs.microsoft.com/fr-fr/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files
4./5. Create and fill an Excel file dynamically with Power Automate » Benedikt's Power Platform Blog (benediktbergmann.eu) (note the "graph id" part there didn't work, but values are added just by using the ID from my excel file creation)
didn't work on the 6/7 yet but I have done similar so it should work )
but still I'm stuck with filtering the item
First attempt : get item with filter Query >> Calculated or choice column (even using the"value" after my column name Columnname/value) don't seem to work.
Second attempt : Filter after + compose> I think it can be the most promising but it's there that I'm a noob : how do I built my expression in order to have the correct column name from my filter ? my filter seems only to have 2 output "item" and "body" (and I don't understand exactly the difference ) .
Third attempt : create a filtered view in my SP list + get item "Limit Column by view" + compose >> all my item are created in my excel file ( no filter ) >> is it only filtering the column, not using the view's filter ?
in my third attempt, the compose use my previous "apply to each" >> is it the same way to write it but using my output for array for attempt 2 ?
{
"Name":"@{items('Apply_to_each')?['ID']}",
"Test1":"@{items('Apply_to_each')?['Query']}",
"Test2":"@{items('Apply_to_each')?['Response']}",
"Test 3":"@{items('Apply_to_each')?['Reference']}"
}
Thanks in advance for your help
