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?

I have the same question (0)

All responses (8)

Answers (1)

Leah Ju Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
CharbelHl. 2 on at

Like (0)

Report

test @User

Was this reply helpful? Yes No
Ralph_Marouni21 37 on at

Like (0)

Report

@User test

Was this reply helpful? Yes No
Ralph_Marouni21 37 on at

Like (0)

Report

@CharbelHl. test

Was this reply helpful? Yes No
Ralph_Marouni21 37 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ralph_Marouni21 37 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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:

Was this reply helpful? Yes No