Hello Community
I wanna build a flow which runs every month and exports all contact from Dynamics365 which have no value in the field "company" to an excel sheet.
I setup everything but it does not work as expected.
I Have following problems:
Here is my flow:
Thanks for any help 🙂
Solved! Go to Solution.
Hi @Anonymous,
Odata filter query ne means not equal, it will return the value not equal to what you specified. So if you want to get all contacts that have no value in the filed Company, you could try to use the function eq to get the null value.
To test this issue, I created a flow likes bellow. The function I used in my flow will return accounts that have no value in the accountnumber field, and exactly that three of the accounts don’t have an account number. It works fine and three records will be exported into the excel file.
Please check the following screenshot for a reference:
More details about Odata filter query, please check this documentation:
Using Filter Expressions in OData URIs
Best regards,
Mabel Mao
Hi @Anonymous,
Odata filter query ne means not equal, it will return the value not equal to what you specified. So if you want to get all contacts that have no value in the filed Company, you could try to use the function eq to get the null value.
To test this issue, I created a flow likes bellow. The function I used in my flow will return accounts that have no value in the accountnumber field, and exactly that three of the accounts don’t have an account number. It works fine and three records will be exported into the excel file.
Please check the following screenshot for a reference:
More details about Odata filter query, please check this documentation:
Using Filter Expressions in OData URIs
Best regards,
Mabel Mao
Oh what a bad mistake I feel kinda stupid now, thanks for your help. However I have another question, I would like to only retrive the active contacts. How can I set this filters?
And where could I see the possible correct values of a dynamics 365 field? For example which options the statecode field has? In the dynamics365 field properties I only see the field type which is status, but no "option values".
My filter looks like this at the moment, but sadly did not work.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
12 | |
8 | |
4 | |
4 | |
3 |
User | Count |
---|---|
13 | |
8 | |
5 | |
4 | |
4 |