You’re offline. This is a read only version of the page.
105
Hi everyone,
I created a table in Powerapps. This table includes a lookup column connecting to the User table.
When I access Excel to complete the data in this table, I manage to publish the information regarding the text type columns. But for the lookup column I can enter the user, but it doesn't publish it.
On the right side of Excel I see a list of users, but only the first 999 users. Not the whole. So I can't search through that list either.
Is there a way to complete the lookup column?
Kind regards,
@luisep , @Kyle_Hess , may be the problem is while the addin is writing the data and in the cell there is a formula then the formula keeps on calculating / recalculating etc.. so try pasting the hard value, rather than the formula
I have tinked with writing addin using javascript and i know the way excel table row count offset behaves , it needs to be handled differntly .. so just thinking out loud
Hi @luisep
In the Power Platform add-in for excel, you should be able to publish the change in mass, formulaic ways using the process Shane Young describes in here: https://www.youtube.com/watch?v=BPkv7S11Zp8&t=1658s
I tend to download the .xlsx for both the lookup table and the table I want to populate, then in the table to be populated I write what I want in the primary/name column (because that's easy for me to remember), then I write an excel expression into the appropriate GUID field, like " =xlookup(name, lookuptable.name, lookuptable.GUID,"") " then copy/paste values in the GUID column and publish.
I have moved tens of thousands of records this way and the only issues I've had is sometimes, for no discernable reason, the "publish" function only publishes the top 100, 300, or 500 rows. I am really not sure why.
No, I haven't found a solution yet. I've watched videos that proposes solutions, but they could not be applied when it comes to hundreds of users, in my case.
Keep looking.
Is there someone else who can help me?
Scenario: a table in the Dataverse that contains more than 1000 rows. A lookup column that I have to fill in with the user's name.
My question: is there a way in Dataverse to directly load usernames into lookup column?
Or does Dataverse not support this functionality like SharePoint?
Hi @dpoggemann,
Thanks for your response.
I attached a screenshot of the right side of Excel. At the bottom you can see the "Publish" button, it is to update the table in powerapps with the modified data in Excel.
The rest of the screenshot are the users that appear to me. But there are only 999.
Is there a way to complete the user's name directly in excel?
Kind regards,
Hi @luisep ,
What do you mean by "publish it"? You should be able to enter the full name of the user into the lookup field and import and it will automatically find the user and set this to the value of the lookup, unless you have duplicate fullname values, then it will fail since it will not be able to match.
What do you mean on the right side of Excel you see the list of users? Can you put a screen shot in to show what you see?
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
