Often the data is not stored in just one place, but you need a combination of multiple data sources.
Yes, you could also solve this with multiple collections, but this is not always a handful version.
In the following examples, I will briefly show how to combine data sources that are identical. But also a variant, how to combine several data sources.
As a little extra, I will show you how I add information to this data source in this collection.
IMPORTANT: It is important to mention here that one per data source gives the Data Row Limit. I.e. Per default 500 are adjusted, why then with 2 data sources maximally 1000 elements can be loaded. (from each data source 500)
It is important to mention that the following solution options are only possible if the columns of the tables match exactly by name. Otherwise this will not work. If you need only some columns which are identical, you can select them with ShowColumns(). If the data is identical, but the column name is not, then you can rename them with RenameColumn().
Combine two same data sources into one collection
Combine two different data sources into one collection
The video is really awesome. in a short time you get an insight & entry into power pages. the incoming questions, as well as the typical developer questions were also answered by our mvp reza & daniel. Thank you very much.
You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.
In some scenarios i or the user would like to see how far the Cloud Flow Process (PowerAutomate) is already after I started it via PowerApps.
Unfortunately it is not possible to use “Respond to PowerApps” multiple times to show me a status update in the PowerApp.
For this we can easily create a StateLog table and check it regularly via timer. Of course, it is important that we send an update to the StateLog entry after milestones in the flow. However, it is also possible that you do not update the entry as in the solution here, but that you create a new entry each time. this gives you other display options in the app.
Here I use the default column “Title”, a text column GUID” (so I can filter by it later) and a number column “StateCode” (so I can do certain things later based on the StateCode)
create a flow in the similar format
It is important that the trigger is followed immediately by the “Create Item”. There you create an entry in the StateLog with the GUID (which you generate and transfer via PowerApp) and of course the StateCode with a naming of the status.
The scopes with the name “Flow Actions” are only symbolic. you can use any actions there. as soon as an important milestone is reached, you simply update the status (or create an additional entry in the statelog -> depending on the desired solution).
You can find the code to copy and paste the flowactions at the end of this post.
create your app
1. the trigger of the flow. Here the flow is attached. I use here with “OnSelect” the function to store a GUID in a variable and then pass this GUID to the flow.
//generate GUID for selection Set(varStateGUID,GUID()); //start Flow wfState.Run(varStateGUID)
2. The timer I use this to check the status in regular intervals (here duration 3000ms -> 3sec).
I have the following settings stored with me:
Repeat: ‘locCurrentState.StateCode<>3’ (variable is set OnTimerEnd)