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,605 Super User 2025 Season 2 on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
sabrinaaa_ on at

Like (1)

Report

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

There you go sir

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
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

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,605 Super User 2025 Season 2 on at

Like (2)

Report
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