“Invalid index: Cannot index property ’’identifier’’ of type String into type List of Variant

Usually this would mean you're trying to directly reference a property (in this case named "identifier") of a local variable you expect to be loaded with a CDT/dictionary containing that property, but in some cases apparently does not contain that (this can result i.e. when a query returns empty).  I don't have any way of making more specific suggestions since you haven't posted any of the code from your rule 'apac_getidentifiersforexcelreport' or told us what it contains, but the first thing you should check for is a place where you're calling i.e. "local!myVariable.identifier", and instead use the property() function to try to access the property in a failsafe manner, i.e. "property(local!myVariable, "identifier", null())"

Thanks Mike.
You suggestion worked for me.

Very helpful, thanks!

=rule!EDD_GetPendingListOfApprover(status_code: "F3").data.businessGroup

please help how can I fix this one if cant find any "F3" status in list of data

Hi mla, Please use property() or index() function to resolve this issue. Its always advisable to use index or property fucntion when you are indexing into any datasubset. See example code below,

property(
  property(
    rule!EDD_GetPendingListOfApprover(status_code: "F3"),
    "data",
    {}
  ),
  "businessGroup",
  ""
)

In the later releases of Appian, they have made a change in the index function where if the provided key is not found, then the function doesn't return the default value. Hence, I would advise you to use the property() function when playing with dictionary/CDT and use the index function when playing with the list. 

thanks 

property(property(rule!EDD_GetEmailEod(status: "F2",businessGroup:ac!businessGroup,regionName: ac!regionName),"email",null)

may i ask how to display null email value if  ac!businessgroup and ac!regionName is NULL. thank you

use index() function to compare the value

Can someone help me in fixing this error with the below code. I tried using the property() but is not giving me any results.

rule!RGRACSLBL_QE_getLabelChangeCountryByFilters(
requestId: 10365,
country: "Germany").id_int