Creating Task Dashboard with SP List

(0) Share

Report

Posted on by chhe

140

Hello,

my plan is to create a task dashboard where multiple colleagues can manage their tasks. This is based on a sharepoint list. This list has these columns:

create	date and time
Sprint	choice (dropdown)
Istzeit	number
Planzeit	number
Priority	choice (option field)
Thema	choice (dropdown)
Title	one text line
ZugewiesenAn	person

I would like to count filtered rows and create from the result a chart.

In the Screenshot I have created a "table" with TextInput... Is that the correct way?

I used this expression:

CountRows(Filter(Backlog;Sprint.Value="7_2020" && Thema.Value="help"))

This works for now. But I want to replace the Value "07_2020" through a dropdown item that looks at my sharepoint list to the column "Thema". But if i insert a dropdown item and choose my sharepoint list, this column does not appear in the value field from this dropdown item. The column is a "choice - dropdown" type in sharepoint.

Could you help me there?

... I have a some other questions and problems with building my task dashboard app. Is it better to write all my questions & problems here in one thread or should I open for each problem a separate thread?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

chhe 140 on at

Like (0)

Report
Hello

if I use this expression to count the rows from my collection:

CountRows(Filter(backlogsammlung;ZugewiesenAn.DisplayName="NAME" && Thema.Value="Organisation" && Sprint.Value="Dropdown1.Selected.Value"))

My Dropdown item is named "Dropdown1" and I have selected the dropdown item 7_2020. But the outcome is 0.
If i replace the "Dropdown1.Selected.Value" through "7_2020" everything works fine and I'm getting the correct result.

What am I doing wrong?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @ chhe:
Q1: In the Screenshot I have created a "table" with TextInput... Is that the correct way?
I think any method is good as long as you get the correct result.
In addition, there are many ways to create tables in PowerApps, I recommend you refer to the following link.
Table function in Power Apps:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table
Collect, Clear, and ClearCollect functions in Power Apps:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
Q2: But if I insert a dropdown item and choose my sharepoint list, this column does not appear in the value field from this dropdown item.
Since the ‘Thema’’s data type is Choice ,I suggest you use Choices function:
Set the drop control’s items property to:
Choices(Backlog.Thema)
I think this link will help you a lot:
Choices function in Power Apps:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-choices
Q3:My Dropdown item is named "Dropdown1" and I have selected the dropdown item 7_2020. But the outcome is 0.
The point is "Dropdown1.Selected.Value" represents a string with content "Dropdown1.Selected.Value", it does not point to the value you want.
Set the Dropdown1’s items property to:
Choices(Backlog.Sprint)
Then try this code:
CountRows(Filter(backlogsammlung;ZugewiesenAn.DisplayName="NAME" && Thema.Value="Organisation" && Sprint.Value=Dropdown1.Selected.Value))

Best Regards,
Bof

Was this reply helpful? Yes No