Announcements
Hi @drhorg ,
I'm not completely sure your system model, but as described (correct me if I'm wrong) that you are storing contacts that has redeemed invitations into a Table called "adx_inviteredemption" and you want to make a report from that.
If you need a SSRS report and this table contains all the Contacts then make report on this Table only.
Also, if you want to Identify which Contact is related to an Account (considering if Contact is lookup, then there will be a field as 'Company' or 'Company Name' or 'Account Name' which is a lookup to its respective Account/Customer table.
Hope this helps
For the PowerApps Portal / Power Pages, the adx_inviteredemption table is where it will be. Also, depending on if you are doing group invites (in which case this next bit is not valid) the Invitation record will also have a status reason indicating it was redeemed and it will also reference the Contact.
Just be aware that by default each Contact could have multiple Invitations and Invitation Redemptions, so when you do your report if you are starting on the Invitation/Invitation Redemption side of things you will want to add something to make it distinct on Contact (or go from the Contact where there is an Invitation Redemption with status reason redeemed instead)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49
