How to use data linking with dynamic table?

​@Dawn.Craven, I discovered that “if you import your data via Google Sheets the connection you make between your data and Lucidchart is dynamic and any changes you make to your data as the project evolves will update in your Lucidchart diagram.” I would take it that this is also the case for Lucidspark and tables. Therefore, if the spreadsheet is in Excel, I would recommend importing it into Google Sheets and changing it automatically or manually into a Google Sheet format before importing.

Thank you ​@aparrish for your reply! Yes, that is a great suggestion.  We use MS365 and I heard that soon they should have that same two-way synch working for us with Excel, so was hoping to get to use that instead. But if it still takes too long, I will look at importing it into Google Sheets as a workaround for now.

However, what I am really trying to use the dynamic table for right now is for the feature of being able to have column headings from my data available to select as either columns or rows (shown in my #3 item in my image) to be able to use it like a pivot table directly in the lucid document -- to group the data by various attributes (i.e. application, status, etc.) very quickly.  I was not understanding how to do that, but I just happened upon the “Assign Lucid Fields” option in the data drop-down menu that I didn’t notice before. That might be what I need.

Hi ​@Micah sorry for the delayed reply, I was out over the holidays.  Thank you for your input and the help article! If I hit further questions as I work through that, will let you know.  

No apology necessary - I’m eager to help if I can!

If anyone has run into something similar or knows whether this workflow can be done, I’d really appreciate any input.

Hi ​@matthew_mahgerfteh, thank you for chiming in! 

Although at the moment linking a dynamic table to a data set beyond a Jira Integration is not supported, the workaround based on assigning specific Lucid fields to your data is a suitable solution mentioned above!

We’re very interested in your feedback and committed to continually improving our products. Please first search the Product Feedback section of this community (with the filter Topic Type = Idea) to see if it’s already been submitted. If so, please add any additional details you’d like and upvote the request - this consolidation helps to refine feedback and properly capture the popularity of the request.

If no one has submitted this idea yet, please create one of your own and be sure to include details about your use case or what you’d like to see in this experience. This will also allow other users with similar requests to discover and upvote it, then add details of their own.

Finally, for more information on how Lucid manages feedback via this community, take a look at this post:

Cheers!