Unanswered

Filter, Set & Return table from flow to reduce burden on PowerApps

(0) Share

Report

Posted on by Community Power Pla...

Hello,

Need a flow to filter, set & return data using flow instead of PowerApps.

The requirement is to build Table3 from Table1 and Table2. Table 2 to get Last Date(means latest date) for each tag X&Y.

The table composed in flow will return to PowerApps to use in a collection name LC_COLL3.

I need because doing it in PowerApps is time consuming(it takes 15-20 sec to load!) for large list of SPO list items

Also sometimes PowerApps throws Rate Limit exceeded error, I am hopeful that if this operation is done at server side, PowerApps will run smoothly.

The photo below is only for explanation, all actual data is in various SPO lists.(Table1 is 200+, Table2 is 5000+)

Annotation 2020-04-27 130853.png

@ChristianAbata Hi friend.

Regards,

Ankit

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (0)

efialttes 14,756 on at

Like (0)

Report
Re: Filter, Set & Return table from flow to reduce burden on PowerApps

Hi!

Two questions:

-Table 1, Table 2 are lists stored in Sharepoint, right?

-Which is the column type of 'Name' in 'Table2'?

-Is Table 3 a list you need to show in your powerApp, or is it an already existing list in Sharepoint and you need to update it?

My suggestion is:

Add a 'Get items' from Table 1

Add a 'Get items' from Table 2 (you will need to activate pagination here, on 'Get items' settings). Assign as its OrderBy input the following ODATA expression:

Date desc

Add an 'Apply to each', assigning 'Get items' from Table 1 output as its input. Now inside the Apply to Each:

-Filter Array, assign as its input 'Get items' from Table 2 output, configure the condition to filter those Table 2 items whose Name equals current iteration Name

-Now, you can get the current iteration latest version by means of the following expressions

first(body('Filter array')) first(body('Filter array'))?['Date'] first(body('Filter array'))?['Tag']

Hope this makes sense

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Filter, Set & Return table from flow to reduce burden on PowerApps

@efialttes Hi,

Two questions:
-Table 1, Table 2 are lists stored in Sharepoint, right?
Ans: Yes
-Which is the column type of 'Name' in 'Table2'?
Ans: Name=Text, Tag=Text, Date=date only
-Is Table 3 a list you need to show in your powerApp, or is it an already existing list in Sharepoint and you need to update it?
Ans: Table3 is an object created in flow which will be returned in PowerApps. It is not in SPO.

@efialttes Please show in a flow(screenshot) if possible. Thanks 🙏

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Re: Filter, Set & Return table from flow to reduce burden on PowerApps

Hi Ankit,

Please use the following url

https://sharepains.com/2020/03/20/create-joins-in-power-automate/

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Filter, Set & Return table from flow to reduce burden on PowerApps

The flow not working for me. Not getting expected values.
@efialttes

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Filter, Set & Return table from flow to reduce burden on PowerApps

Can anyone help please?

Was this reply helpful? Yes No