
Announcements
Hi!
Non-Techie person here 🙂
I was trying to explore and learn about Flow and Filtering/Getting Data from D365 Finance & Opeartions., I essentially wanted to Filter on the D365 FinOps Entity AssetJournalLines and Filter by TransactionType.
In order to get this filter working I couldn't use "TransactionType eq 'Acquisition' " as it wasn't accepting that! After talking to one of our Developers they helped me by explaining enums (makes perfect sense!) and the query I had to use which ended up being TransactionType eq Microsoft.Dynamics.DataEntities.AssetTransTypeJournal'Acquisition'
My question is - Is there any way to determine the enums without using a Developer or an easy way to filter this?
The JSON file that gets produced doesn't give any indication that its an enum or even that the field is called AssetTransTypeJournal rather then TransactionType
I am mostly trying to figure out a way to sell/train my team and get them using Flow!
Thankyou for your time 🙂
Hi @PowerAppUser87 ,
You could take a try to add a “Filter Array” action under your AssetJournalLines action, and then you could filter on the D365 FinOps Entity AssetJournalLines by TransactionType.
Please let me know if your problem could be solved.
Best regards,
Mabel