Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Inventory Count/QC Check App

(1) ShareShare
ReportReport
Posted on by 2
I am trying to build an app that will allow me to fill in Date, Part Number, Location, Stock Qty, Sample Qty and Discrepant Qty through a sharepoint. The issue I am running into is when the app is booted up I need it to autofill the Part Number and Location and as counts are being submitted for it to automatically populate the next part number and location on the list. Once the app is closed on next bootup to continue where was left off.
  • CW-14101847-0 Profile Picture
    CW-14101847-0 2 on at
    Inventory Count/QC Check App
    So essentially I have a sharepoint list with corresponding Part Numbers and Locations and I have a sheet built to add stock qty, sample qty, and discrepant qty. As well as a submit button and reset button. My issue is pulling the first row part number and location and it auto populating in my data cards and then when i enter my counts submitting it populating the next row part number and location. But I also need it to function when i close the app it picking up at last one that I left off on.
  • ANB Profile Picture
    ANB 7,060 on at
    Inventory Count/QC Check App

    I will try to answer it, however I didnt get the complete query. For auto populating Part Number and Location, you can use Last function. 

    Last(SharePointList)
     
    And for Part Number and Location, you have default property of control to be Last(SharePointList).'Part Number' and Last(SharePointList).Location . Please check https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-first-last
     
    Please elaborate more on other part of query.
     

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.


    Thanks,
    ANB
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard