filtration based on requirments

(0) Share

Report

Posted on by Ralph_Marouni21

hii,

i want to Filter lookup position based that it's vacant and end date is from date to max 1 month (contract)

tables are Position and contract with these column respectively:

Start date,Department(lookup),Parent position(lookup on itself),employee(lookup),Vacant(Yes/No).

employee(lookup),position(lookup),Start date,end date,Department.

can someone help?

All responses (8)

Answers (1)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

filtration based on requirments

Hi Partner,

The calculated field should on the contract(child) entity, Right?

If so, you can use date field from position(parent) entity, like this:

1)Insert function:

2) Find position lookup:

3)insert . then you can select field of position entity:
Ralph_Marouni21 37 on at

Like (0)

Report

filtration based on requirments

@Leah ju even if the start date in a table and the end date in another table?
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

filtration based on requirments

Hi partner,

Yes, we can't achieve it directly through these two date fields in advanced find query.

It doesn't have to be in code to do this, Maybe you can create one calculated field to calculate difference between two dates:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields#functions-syntax

Then you can use the calculated field as the filter in Advanced find query.

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah
Ralph_Marouni21 37 on at

Like (0)

Report

filtration based on requirments

@LeahJu yes i want to filter date from start to finish not more than 1 month but i think we can't do it unless in codding
Ralph_Marouni21 37 on at

Like (0)

Report

filtration based on requirments

@CharbelHl. test
Ralph_Marouni21 37 on at

Like (0)

Report

filtration based on requirments

@User test
CharbelHl. 2 on at

Like (0)

Report

filtration based on requirments

test @User
Leah Ju Microsoft Employee on at

Like (1)

Report

filtration based on requirments

Hi Partner,

Yes, you can filter parent records(position) based on child records(contract) in Advanced Find.

Add row for vacant field, and add related entity for contract entity, then you can select field of contract.

And i don't understand you said: and end date is from date to max 1 month (contract)

Can you explain? Does it mean the start to finish time is not more than 1 month?

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah