[PowerApps] Lunch Request App

[Requirements]

- RCK(Rotork Controls Korea) employees working in Rotork YTC should be able to access the app

- The app should provide canteen menu

- Users can request and cancel lunch oneself via app

- Requests should be accpeted only before 10AM

- Total number of lunch request should be calculated and shown on the app

 

[OS] 

N/A

 

[Development Language]

PowerAutomate - PowerApps

 

[IDE]

N/A

 

[Setting]

- Change to Information Technology environment 

 

[Code]

N/A

 

[Test]

 

- Request lunch with the button

 

- Cancel lunch request

 

- Check lunch requester list

 

 

[Lesson Learned]

- How to insert most recent image file from ShrePoint list

First of all, create a SharePoint list and add an image column

 

In the app, set a variable which saves a item ID by selecting most recently created one

Set(
    menuID,
    First(Sort('Canteen Menu',Created,SortOrder.Descending)).ID
);

 

Create an image object and input the image

LookUp('Canteen Menu', ID=menuID).menu.Large

 

Then the app calls the image when the app starts

 

 

- Count number of items in SharePoint list with filter condition

CountRows(Filter('RCK 중식 식사 신청', Text(Created, "yyyy-mm-dd")=Text(Now(), "yyyy-mm-dd")))