I am triggering a flow from Powerapps and after extensive google/searching here etc i', lost 😞
I have my Power apps trigger
I have a 'Get Items which is filtered by date
I have a 'Filter array' which returns the information correctly
What i want to do is now take that information and turn it into a HTML document but i dont want to show all the returned information and i don't want to use 'Create HTML table' action.
What would be my next step?
this is all my flow has at the moment as i dont know what to do next
if i add a parse Json after Filter Array it asks me for content which one do i use?
Body or Items?
The it asks for a schema
if i put a compose after filter array and use output from Array the parse json still asks for scema
mmm @gazzo1967 when you use get items you are getting lot of values from a list, so when you use filter query I asume you are getting just specific values, I don't know if I'm understhand ding well but what you need to di is just select one of all values returned by filter query?
Imagine that you have in your list this values
So using get items you extract all of the data theb filter array allows you to get specific data like from all values just get the data with 2. So applying filter query you can get this
then I'm asuming that you need to use just one of that filtered values like just convert into a table the row name Example?
Again thank you for the response 🙂
I have added the Create HTML Table as my next action and found the Columns 'Custom' and added the fields i want 🙂 but the next step is to email that complete html table but it sends separate emails for each entry 😞
oh @gazzo1967 I understand, what you need to do is manage variables, pleasee see my example
see my compose could be your table, so you can use that output into an email after compose. 😉
Hi @gazzo1967 ,
First method is to use Filter Query to filter items directly. In this way, you do not need to use Filter array to filter items, you can also easily configure Create HTML table action.
Please check this article to get more details about the usage of Filter Query:
For the usage of Parse JSON action, please check this article:
You could also refer to the following image to configure flow.
Hope this helps.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.