Unanswered

PowerApp generated against 'Application User' let me create a record without a 'AAD user object ID'

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I was using the 'Application User' table to cache the users from the Office365 connection. It was working great until the generated PowerApp against the 'Application User' table let me create a record with a valid EmailPrimary but the 'AAD user object ID' was blank/NULL/empty. I cannot UPDATE or DELETE this record. I have tried the RemoveIf('Application User', true) and it did remove all records BUT this one bad record. This is a very big problem because the 'EmailPrimary is also a 'unique' record and the email address was a valid email address, therefore, I cannot even create another record for this particular user.

Any help? How do you delete all records when the identity is blank/NULL/empty?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi EdRGray,

Did you mean the "Office 365 Users" connection?

It seems that PowerApps cannot automantically create the app using this connection. May I know more detailed information about your app. Like how did you create he record in app?

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I did NOT attempt to generate the App against that connection. I generated the App against the Standard Entity provided by the Common Data Services named 'Application user'.

I was using that generated application to populate the values returned by the Office 365 connection. For example, generate an app based on the standard entity named 'Application user', then run that generated application and begin to populate the data with cut and paste.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Everything was working fine until somehow one of the entries ended up/somehow getting a NULL/empty record into the identify column.

Error Publishing
Details:
Original data contains rows without identity. Identity fields: AAD user object ID

I only have 1 row remaining in the table now because I tried to remove all records and start over. I did that with this command in a PowerApp.

RemoveIf('Application user', true)

That command removed all rows but the one NULL/empty row.

If there is another method to truncate a table, or remove all rows, I would use that and start over.

I have no idea why one record ended up with the NULL/empty row. I had created several already before that happened.

Here is the error message from within PowerApps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can anyone help me with this issue?

Was this reply helpful? Yes No