
Announcements
Hi,
I'm still learning this so please bear with me if I ask any dumb questions or if there is an obvious answer to this.
I have several SharePoint lists feeding into a single powerapp, the way of selecting which list will be the source to interact with is a drop down list which controls a variable which sets the source dataset. All the sharepoint lists are identical. These all have a lookup to a single list which is a list of services along with a number representing time. I then use that to interact with dates recorded in the list to see whether targets are being met. A problem I encountered is that using a lookup of the working days in the sharepoint list produces a record which cannot be used in the calculation. I then constructed a flow to convert this into a usable number for calculation. The catch being that I now have several flows, one per list. I want to use a single flow instead inside the powerapp to replace all the individual ones. This flow would look at the selected value in the drop down when the user clicks submit, look on the list and then return the appropriate time frame to be added to the relevant column of the sharepoint list when the form data is submitted. Can anyone advise how I can use powerapps flow to achieve this? The data selection variable works perfectly, its just getting the correct data in the timeframe column before it is submitted, instead of triggering when a new item is created.