Unanswered

Contacts that redeemed invitations

(0) Share

Report

Posted on by drhorg

My requirement is to run a report of all contacts that redeemed invitations. I can query based on the customers in the adx_inviteredemption entity, by filter for customers that are contacts. is this correct?

Not entirely clear if I can use this table/column

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

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)

Was this reply helpful? Yes No