Answered

Salesforce Connector - Disabling User Based On Date In Salesforce Resource

(0) Share

Report

Posted on by Alex_Noble

Hi,

We're trying to put together a flow whereby once a day at the close of business it checks if the end date of the user matches todays date and if it does, then disable the account in azure AD.

I can see the part to update azure ad account to disabled, that's fine. The issue i'm having is filtering out the record from salesforce, then comparing the date to todays date and if it matches then action.

Can anyone help with filtering out what we need and then the best way to compare it to todays date please?

This is where we got to but it doesn't seem to pull the record we need when we check the raw data, so the filter below doesn't work.

I can provide the data output if required but I will have to go through it and remove any sensitive data.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alex_Noble

1. You can use the formatDateTime function to convert both sides of the condition to the same date format, for example: formatDateTime (utcNow(), 'yyyy-MM-dd')
2. You may encounter the problem of jet lag, which causes the two sides of the condition to be unequal. You can consider using the convertFromUtc or convertTimeZone functions.
I think this link will help you:
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Best Regards,
Levi

Was this reply helpful? Yes No
Verified answer

Alex_Noble 9 on at

Like
a
(0)

Report
Copy link

Link copied!

We managed to solve this by looking at our other Salesforce system and getting the Team Members object, then once we had all the data with no filter, we could see date format is yyyy-mm-dd so we set the filter query as:

End_Date__C eq formatDateTime(utcNow(),'yyyy-MM-dd')

We then do a condition which is this End Date is equal to formatDateTime(utcNow(),'yyyy-MM-dd')

If yes then disable the account.

Was this reply helpful? Yes No