microsoft / coe-starter-kit

Other
748 stars 220 forks source link

[CoE Starter Kit - BUG] Edit Data option greyed out performing configure CoE settings table steps of core components installation #800

Closed michaelgottwals closed 3 years ago

michaelgottwals commented 3 years ago

Describe the issue

I have been following the instructions to setup the CoE Starter Kit (Option 2: Import the solution into Dataverse for Teams environment) per article https://docs.microsoft.com/en-us/power-platform/guidance/coe/setup-core-components. I have successfully implemented all steps up to "Configure the CoE Settings table". I am performing Option 2 of the "configure CoE settings" steps and substep e. "Select Edit data" is greyed out for me, preventing me from entering the required values. (See screenshot 1 attached) I tried using the "Edit data in Excel" but that exports a spreadsheet to my local downloads folder which contains a table with all of the columns from the CoE Settings table and no rows. This indicates to me the Teams Dataverse table contains no rows which may be why the "Edit data" option is greyed out. I thought maybe there was a link from the exported spreadsheet to the Dataverse table but I did not see any data connection defined there. This appears to be a bug as the behavior is not matching the Microsoft provided instructions.

Screenshot_1

Expected Behavior

I expect the "Edit data" option to be clickable when performing configure CoE settings step as the Microsoft provided instructions state.

What solution are you experiencing the issue with?

Core

What solution version are you using?

CenterofExcellenceCoreComponentsTeams_1_998_managed

What app or flow are you having the issue with?

CenterofExcellenceCoreComponentsTeams

Steps To Reproduce

Steps to produce the error have been described in the issue description

Anything else?

No response

JeneferM-MSFT commented 3 years ago

It does appear that the product has changed here unfortunately.

If you can Edit data in Excel, you are unblocked. You can add your row and publish it back up.

Open the file > Enable Editing image

Ignore this error if you see it, just hit OK image

Fill in the information and hit Publish image

michaelgottwals commented 3 years ago

Hello Jenefer,

I open the file on my local downloads folder, it appears I am already in edit mode by default as I do not see the Enable Editing button. I added a value for the Company Name column and saved the document. However, I do not see any option publish nor do I see any information in the Data connections ribbon option showing it is linked back to the Teams environment. Can you provide a little more details to help me out?

Thanks.

Kind Regards / Mit freundlichen Grüßen,

@.***D77408.1A256E20]https://www.boehringer-ingelheim.us/

Michael Gottwals IT EDS Content Life Cycle Services Boehringer Ingelheim USA Corporation 900 Ridgebury Road, Ridgefield, CT 06877 P: +1 203-778-7305 @.**@.> Facebookhttps://www.facebook.com/BoehringerUS/ | Twitterhttps://twitter.com/boehringerus | Instagramhttps://www.instagram.com/boehringerus/ | LinkedInhttps://www.linkedin.com/company/boehringer-ingelheim

From: Jenefer Monroe @.> Sent: Thursday, July 8, 2021 1:35 PM To: microsoft/coe-starter-kit @.> Cc: Gottwals,Michael (IT EDS) BI-US-R @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] Edit Data option greyed out performing configure CoE settings table steps of core components installation (#800)

CAUTION! Please do not click links or open attachments unless you recognize the sender, this email is from an External Sender (outside Boehringer-Ingelheim)

It does appear that the product has changed here unfortunately.

If you can Edit data in Excel, you are unblocked. You can add your row and publish it back up.

Open the file > Enable Editing [image]https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fuser-images.githubusercontent.com%2F62659043%2F124979718-a519ab00-dff0-11eb-8fae-b902718af9c7.png&data=04%7C01%7Cmichael.gottwals%40boehringer-ingelheim.com%7C99311be05f764291768108d94247898e%7Ce1f8af86ee954718bd0d375b37366c83%7C1%7C0%7C637613697848023569%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=W%2Bg7PVewF3yQL%2FYPf6nLElQc5RRR3%2FKy%2BgsPHtsAhrw%3D&reserved=0

Ignore this error if you see it, just hit OK [image]https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fuser-images.githubusercontent.com%2F62659043%2F124979779-bc589880-dff0-11eb-9ec1-1c992ad577f4.png&data=04%7C01%7Cmichael.gottwals%40boehringer-ingelheim.com%7C99311be05f764291768108d94247898e%7Ce1f8af86ee954718bd0d375b37366c83%7C1%7C0%7C637613697848023569%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=h6Viab0xnSuyRhsEYv3wsfCDDJ9ZUm3Sbc77%2FGfeDQE%3D&reserved=0

Fill in the information and hit Publish [image]https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fuser-images.githubusercontent.com%2F62659043%2F124980083-2e30e200-dff1-11eb-83a3-6d8252500421.png&data=04%7C01%7Cmichael.gottwals%40boehringer-ingelheim.com%7C99311be05f764291768108d94247898e%7Ce1f8af86ee954718bd0d375b37366c83%7C1%7C0%7C637613697848033527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=LA%2B33V79l%2BLS0BVlgC4zt3ueYK6vh1eoTdCtheMQ6Oc%3D&reserved=0

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fcoe-starter-kit%2Fissues%2F800%23issuecomment-876692661&data=04%7C01%7Cmichael.gottwals%40boehringer-ingelheim.com%7C99311be05f764291768108d94247898e%7Ce1f8af86ee954718bd0d375b37366c83%7C1%7C0%7C637613697848033527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=rcxKhsrU2TE0aWiDwIfApQzQHkpifDvWPqXCcXzmLEk%3D&reserved=0, or unsubscribehttps://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAS4OKNI54E7GNQF56XXGCS3TWX4XTANCNFSM5ABK2F5A&data=04%7C01%7Cmichael.gottwals%40boehringer-ingelheim.com%7C99311be05f764291768108d94247898e%7Ce1f8af86ee954718bd0d375b37366c83%7C1%7C0%7C637613697848043481%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=MEyxQWi4UoNCWel%2Fy7IX7dOOMbrL%2B6tbEShx41MUkYo%3D&reserved=0.

This e-mail is confidential and may also be legally privileged. If you are not the intended recipient please reply to sender, delete the e-mail and do not disclose its contents to any person. Any unauthorized review, use, disclosure, copying or distribution is strictly prohibited.

JeneferM-MSFT commented 3 years ago

Sounds like you dont have the addin. We will see if there is some workaround

michaelgottwals commented 3 years ago

Hello Jenefer, Just curious as to what the excel add-in is that you were referring to? Also, any ideas for a workaround to this issue? I see the July 2021 CoE starter kit was released today in Github, any chance this version addresses this issue?

JeneferM-MSFT commented 3 years ago

Your issue is a product change, not a change in our toolkit, so upgrade will not help.

We are exploring a workaround but the good news is that you can proceed without this step, we only rely on this table for formatting things so you can get your inventory going.

Here is a blog a out the Excel Add-In

michaelgottwals commented 3 years ago

Thanks for the information it is much appreciated. Unfortunately my company blocks office add-ins so I am unable to install that. So if I skip this step is their some way to update that table in the future? It sounds like not until a change is made to the CoE starter kit and if that is the case is this fix/change planned for a future version?

michaelgottwals commented 3 years ago

Also, one other question, do you think it makes sense to install the latest release of the CoE starter kit at this stage to get the latest and greatest?

JeneferM-MSFT commented 3 years ago

We have just removed the CoE settings from the setup instructions entirely and now surface these as env variables. Will release with August.

michaelgottwals commented 3 years ago

Great News. I took your advice and moved on with the installation, How do I get the new functionality into my existing Dataverse for Teams installation once it is released in August?

JeneferM-MSFT commented 3 years ago

Please see our documentation: installing updates

mikefactorial commented 3 years ago

@michaelgottwals This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.