Column Chart with IF statement

(0) Share

Report

Posted on by ernu

140

Hello all,

I want to use column chart with my sharepoint list. You can think my list as below;

According to this list, I want to create a column chart like this;

I want to show "approval status" information as column according to ID information. For example, two column charts should appear for ID55.

Normally this ID information comes from another sharepoint list (with gallery_X.selected). I need to send query with this ID to another sharepoint lists (also another gallery). Because ID column common these to sharepoint lists.

How can I handle this?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Does anyone have an idea? 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So do u bassicly want to GroupBy Approval status based on ID? Or do i see this incorrectly. Please explain a bit more possible manually create an expected output and show that.

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

For example;

I selected ID-55 project in a different sharepoint list (in powerapp) and after that will open a new screen in app.
In this scren, I want to show column chart but with different list source (as this table). I know selected ID-55's project and need to get these ID's "Approval Status" quantities and then send to column chart. But this Approval status quantities in the different sharepoint list..

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Are there any relations between the 2 lists? If not how would u know which status is connected to which id?

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Yes, there is a relations these 2 lists.
ID and Project Name common columns in these lists.

So, if I can write the script like "ıf this ID and Project name equal to X and Y, get the total Approval Status of this ID and Project name.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

U should be able to do this pretty easily using placeholder items. Such as a dropdown or combobox.

List 1: list1
list1_id(PK)

List 2: list2
list2_id(PK)
list_name
list_status
list1_id(FK)

I think i have exactly the same setup as u except i use SQL Server instead of Sharepoint.
Can u send me the lists written out as the example above? Or a simple list of both without the FK but just show the relation between the 2 lists. When u've done this i should be able to write u a workflow which gets your outcome.

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

First of all thanks for your interest and answer.
Actually I can focus on the my main list for now. You can see a sample list like my original list in below.

I have Project ID, Project Name, Project Documents, Documents Level and Document Approval Status..
I need some visualize and get insight from this list. Like;
- How many L1 level documents does project 8 (ID) have?
- How many documents are waiting for approval in project 10?

I can increase the examples. But I don't want graphs to summarize the whole list. I want customized graphics that will depend on the selected ID and project name. Maybe I explained better now 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I now fully understand what u want to create. May i suggest using PowerBI for this? It is more suited for the thing you are trying due to being focussed on visualization. It is probably possible in PowerApps but if u just want to show graphs and make a dashboard then PowerBI is better. If that is not an option for you i will see if i can recreate your dataset and make it work.

Was this reply helpful? Yes No
ernu 140 on at

Like (0)

Report
Copy link

Link copied!

Actually, I prefer the power Apps solution primarily because of want to manage over just one application/platform.

Was this reply helpful? Yes No