Unanswered

How to shift the "Progress Summary" part based on the latest input

(1) Share

Report

Posted on by sabrinaaa_

Currently this issue I'm facing is the input from any of the row, however when I input the following content from "% Actual Progress" and "Progress Summary" are still the same result from the month Jan, if I input from different months the content inside the box won't be updated.

Any solutions to this, such as the key expression I can use?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Can you please copy/paste your code here so we do not need to retype?

thanks in advance

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!

hi @sabrinaaa_ ,
try using this Value('Project Name'.Id)

Was this reply helpful? Yes No
sabrinaaa_ on at

Like (1)

Report
Copy link

Link copied!

LookUp('INVITE Project Summary Dev','Project Name'.Id=ThisItem.ID).'Progress Summary'

There you go sir

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
you can try thus:

LookUp('INVITE Project Summary Dev', 'Project Name'.Id = ThisItem.ID && MonthColumnName = SelectedMonth).'Progress Summary'

you need to rename to your needs.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
sabrinaaa_ on at

Like (1)

Report
Copy link

Link copied!

Unfortunately I have selected the wrong part if you could refer to this one based on this coding, are there any expressions to be able to solve this based on the case?

If(IsBlank(LookUp('INVITE Project Summary Dev','Project Name'.Id=ThisItem.ID).ActualProgressProject),"-",LookUp('INVITE Project Summary Dev','Project Name'.Id=ThisItem.ID).ActualProgressProject&"%")

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
try this onselect of gallery1:

ClearCollect( ColMatchingParts, Filter('Matchings Database', PartFromFirstList = Gallery1.Selected.'Part Number').PartFromSecondList )

and this on items property of gallery2:

Filter( 'Second Parts List', 'Part Number' in ColMatchingParts )

you might need to rename to your needs.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No