Unanswered

Sending filtered gallery items to Power Automate

(0) Share

Report

Posted on by mmollet

3,187

First I want to say that I know this has been asked and answered before but for some reason I can't translate those example into what I need. Mostly due to not knowing exactly how all the functions used work I suppose. My goal is to send the rows from a filtered gallery in Power Apps to a flow.

I assumed using Json to send it as a string would be my best bet here and some research I think confirmed that.
I have Gallery1_2 which is filtered by UserName and also by 2 date pickers to see time entries for employees
I want to send the filtered results to the flow called 'EmailWeeklyHours'
I have had an issue with images type being in the list. I can make it go away by including the binary but I will never need this so it seems like a waste of computing power. I disabled attachments to see if that would resolve it and it did not. (dont really care at this point as long as I get the items)
My next issue is that there are labels in my gallery as well as a rectangle for some borders and those seem to be being sent in the json as well.

I only need to send the data from these columns to the flow: "TaskCategory", "StartTime", "MinutesOnTask"

I have successfully sent something to a flow and got an output in json but it was just a bunch of "MinutesOnTask" objects with the exact same value. I need to get the proper Json formatting first of all and then get the proper formula.

Not sure how to make this work and any help is appreciated.

EmailWeeklyHours.Run(JSON(Gallery1_2.AllItems,JSONFormat.IncludeBinaryData) -> cannon serialize tables or type control error

EmailWeeklyHours.Run(JSON(ShowColumns(Gallery1_2.AllItems,"TaskCategory", "StartTime", "MinutesOnTask"), JSONFormat.IncludeBinaryData)) -> No errors and sends to flow but output was all messed up

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet

It's not better to pass Date Picker Selected Dates to Flow and filter Items from Data Source in the flow then create a HTML table format it in CSS and pass it to Email ? or convert outcome to CVS and add it as a attachment ?

use PowerApps(v2) Trigger create two parameters to pick dates than add Action Get items use ODATA filter pass the dates retrieved from power apps to the Filter and get all Items in range of dates

Base of the outcome of the Get Items Create HTML Table Map data from Get Items and that's it

Was this reply helpful? Yes No
todorovicdijana 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @mmollet , did you manage to do this? I tried with this formula but it does not send anything valuable to flow 😞

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

I ended up just filtering the SP list and working completely in the flow. I send variables from powerapps and then use them to filter arrays and compose rows etc as I need in flow. I now have a super complex flow but it does exactly what I want and works well. I have learned that you can use parameters in the JSON function to exclude controls as well as some other things based on what you need. The one for excluding controls was something about if it makes an error leave it behind essentially. Sorry I cant help more :^/

Was this reply helpful? Yes No
todorovicdijana 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply! 🙂
I actually used JSON function and in the flow just with parsing the trigger outputs got pretty much straight forward values, all except Choice column, that one with this JSON formula passes from App side to the flow Value (number) and not Label (text)...

Was this reply helpful? Yes No