I'm trying to use a powerapp and powerautomate to query an email address within our customer records in D365FO.
I am having absolutely no luck and have tried multiple entities and combinations. Is it at all possible to query the system as a whole i.e. party by an email address input? The closest I got I was receiving errors that I was not including the account number but I can't include that as my only input is email address.
All I need is to receive feedback if positive and then i can end my query there and feedback to the powerapp 😕