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:

Connecting to Data

All responses (6)

Answers (0)

mmbr1606 11,999 Super User 2025 Season 1 on at

Like (2)

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

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
sabrinaaa_ on at

Like (1)

Report

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

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&"%")
mmbr1606 11,999 Super User 2025 Season 1 on at

Like (1)

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

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
sabrinaaa_ on at

Like (1)

Report

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

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

There you go sir
anandm08 1,936 Super User 2025 Season 1 on at

Like (1)

Report

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

hi @sabrinaaa_ ,
try using this Value('Project Name'.Id)
mmbr1606 11,999 Super User 2025 Season 1 on at

Like (1)

Report

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

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

thanks in advance