web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Use flow to lookup dat...
Power Automate
Unanswered

Use flow to lookup data for powerapp

(0) ShareShare
ReportReport
Posted on by 28

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.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard