Forum Discussion

simonmoseley's avatar
simonmoseley
Regular Visitor
9 years ago

Templates using SharePoint lists

Hi,  I have created some reports added some charts and slicers linking to a SharePoint site that I would like to use as a template for other subsites. My questions are:- Should I save my report a...
Need Help
simonmoseley's avatar
simonmoseley
Regular Visitor
9 years ago

Hi,

 thankyou for taking the time to get back to me. I thought the template was the better option and feel better for having that clarified. I will also add the paparemeter to promp the new data source.

 

The errors I get are warning triangles in the Queries field on the left which are expression errors the key didn’t match any rows in the table. Details Key=Record Table =Table. I click go to error then edit settings. When the Navigation windows pops up I selected the resource which is the same as the Queries on the left. On the applied steps it shows a duplicate called renamed columns1 which I delete, close and apply and all works ok until I get a site without any data in it I get a picture of a table next to the queries then when I apply and close I get Expression.Error The column id for the table wanst found. Can I get round this or will I have to populate it with some kind of demo data?

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi simonmoseley,

The error which you get again indicates that the column has been deleted in the data source. You should have some steps in your query that explicitly reference the deleted column. You can open advanced editor on  your query, then find the deleted column in it, then correct the codes in  advanced editor.

Thanks,
Lydia Zhang

  • simonmoseley's avatar
    simonmoseley
    Regular Visitor
    9 years ago

    Hi,

     thanks again for your help. I think my issue is because its a new site, it has the same feilds but no data as yet and I will have to tell my boss we cant show anything untill all the fields have something? I dont get this error picking other subsites with Data

    Below are a few screen shots which may help explain myself better

    At this point I go to the error and pick the same table I then get this

    When I clicked Renamed Columns I get this

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      simonmoseley wrote:

      Hi,

       thanks again for your help. I think my issue is because its a new site, it has the same feilds but no data as yet and I will have to tell my boss we cant show anything untill all the fields have something?

      Hi simonmoseley,


      Yes. Or you would  need to delete "Rename Columns" step in Applied steps.

      Thanks,
      Lydia Zhang