How to edit data using Excel in a lookup column (User)

(0) Share

Report

Posted on by luisep

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,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
luisep 105 on at

Like (0)

Report

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,

Right side Excel.JPG

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @luisep ,

Sorry, I have never worked with this Office add-in.

Thanks,
Drew

Was this reply helpful? Yes No
luisep 105 on at

Like (0)

Report

Thank you anyway

Was this reply helpful? Yes No
luisep 105 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Kyle_Hess 2 on at

Like (0)

Report

@luisep did you ever find a solution for this issue? I'm facing the exact same problem right now and I'm not sure how to proceed. Thank you!

Was this reply helpful? Yes No
luisep 105 on at

Like (0)

Report

@Kyle_Hess
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.

Was this reply helpful? Yes No
Verified answer

whyonearth 126 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CU25061832-1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No