Answered

attendance control

(0) Share

Report

Posted on by Adinator

212

Hello Community,
my boss has a meeting every morning. the heads of other departments take part in the meeting, e.g. HR or marketing. he now wants to have an attendance check, which department is present. i have created a sharepoint list with column "date" (setting is date and time) then a column with marketing, logistics (setting is YES or NO). The attendance check should simply be created in powerapps on a page where the names of the departments are and next to it you should click if they are present. when you are done you should click on a button and the content will be transferred to sharepoint. @BCBuizer

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

This seems like a great time to use a form actually. I generally like to build my own forms but this seems pretty simple and cookie cutter.

Make a list with columns like you have in your image. A date and then each dept for example.
In your app, drop in a new form and and it should have all the controls built out for you already. You can then just use SubmitForm(YourFormName) to submit the attendance to the SP List.

Was this reply helpful? Yes No
Adinator 212 on at

Like (0)

Report
Copy link

Link copied!

HI @mmollet ,
can you please show me exactly how you mean it.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!
Sure!

Create a SP List with columns MeetingDate, and then one for each of your departments at the meeting. (do not just use Date as the column name as that is a reserved word in Power Apps and most other programming and could cause issues at a later point in the app)
Create a screen on your app and select insert and then select Edit form from the Popular category. This will drop in an edit form onto your screen.
Now you will want to select the form and on the right hand side properties tab find the default mode and change it to new. (should be edit to start with)
now where it says data source in that menu, click the dropdown and either select your SP list or if it does not show up then do the following:
click add data at the top of your screen. in the search bar type SharePoint and then scroll all the way down. You should see Share-Effect, SharePoint, Short URL etc. Click on SharePoint. Follow the steps to link your SP list to your app then repeat step 4.
Now drop in a button or text box whichever you prefer. In the OnSelect property of that control add the following code: SubmitForm(YourFormNameHere)
Now click the form again. In the top left of the screen hit the dropdown and click the property called OnSuccess. This is where you will want to add code if you want anything to happen once the form is submitted. For example if you want the user to be taken back to the home screen then: Navigate(HomeScreen) should be added to the OnSuccess property of the form.
Let me know how this goes! We will get you up and running today for sure! 🙂

Was this reply helpful? Yes No
Adinator 212 on at

Like (0)

Report
Copy link

Link copied!

Hi @mmollet , so right it has unfortunately not worked. I have made a screenshot and hope that you can help me here. I have it in german. please don't get confused.

Was this reply helpful? Yes No
Verified answer

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

No problem! You will want SubmitForm(Form1) in your case or you will have to rename Form1 to match what you have in your SubmitForm function

Was this reply helpful? Yes No
Adinator 212 on at

Like (0)

Report
Copy link

Link copied!

Thanks, but when I press the button, the page disappears. Do you have any idea how I can get to the home page after running it?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Yeah sure go to the OnSuccess Property of the form itself and add a navigate function to your home screen there.
OnSuccess of form -> Naviagte(HomeScreen)

Also here is what I did to get the sort you wanted to work for me:
Screen's OnVisible property: ForAll(Distinct(Test,FirstName) As record, Collect(topIndex, LookUp(Sort(Test, order, SortOrder.Descending), FirstName = record.Value)))
Gallery's Items property: topIndex

What this is doing is running a forall function over every distinct name in my SP List. In this forall function I am collecting the highest indexed item to a local collection for each person. At the end all we are left with is the top index for each unique user. This will have to be modified slightly to work in your app but I have tested this on my end and it works very well.

Here is the gallery populated with the code above. This can be compared to the SP list below to validate results.

This is the SP list data that I am using to test this solution. Yours will be different obviously but this should help you see what I did with the code.

EDIT: I posted this as an answer to another question here in this thred. Sorry for the confusion!! @Adinator im sure you were wonder wth is this guy talking about lol 😂 sorry about that!

Was this reply helpful? Yes No
Adinator 212 on at

Like (0)

Report
Copy link

Link copied!

no, i am not looking for that, when i click on the button that adds the content to sharepoint then it should also jump back to the home page.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Naviagte(HomeScreen) will need to be added to make that happen. You can add this to the onsuccess of a form for example or add it at the end of the on select of a button or text control

Was this reply helpful? Yes No