Unanswered

InvalidTemplate substring

(0) Share

Report

Posted on by SeanEli

Hi Everyone,

I was following this video https://www.youtube.com/watch?v=95sPDky0bU0&t=21s to export my filtered gallery to CSV file. Unfortunately I'm having this error.

I'm not very familiar with composing the expression but from the video, it's supposed to delete the extra and on the outputs.

Hope anyone help please.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please share the expression you are using

Was this reply helpful? Yes No
SeanEli 14 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I got it from the video

if(endsWith(outputs('Compose'),' And '), substring(outputs('Compose'),sub(length(outputs('Compose')),5), length(outputs('Compose'))), outputs('Compose'))

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I believe the third parameter is causing an issue. Substring takes in 3 parameters:

1. Source string - the original piece of text
2. Start index - the index/position where you want to start extracting from
3. Length - the number of characters you want to extract (from the start index)
An example is below:
orange
substring('orange', 1, 3) would return ora
substring('orange', 2, 3) would return ran

Check your length parameter isn't set to 27 if your start index is greater than 1 because it will try to extract past the end of your text .

Try using this link :https://onlinestringtools.com/extract-substring to put in your values and test it out.

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
SeanEli 14 on at

Like (0)

Report
Copy link

Link copied!
Hi @Ankesh_49 ,

Thanks for your reply.. This is the expression on the Compose action, based on the video. The variables here are filters on my PowerApps gallery.
concat(if(not(equals(variables('Cluster'),'All')), concat('Cluster eq ''', variables('Cluster') ,''' and '),''), if(not(equals(variables('Group'),'All')), concat('Group eq ''', variables('Group') ,''' and '),''), if(not(equals(variables('Status'),'All')), concat('Status eq ''', variables('Status') ,''' and '),''), if(not(equals(variables('Reporting Time'),'All')), concat('Reporting Time eq ''', variables('Reporting Time') ,''''),''))
Say I only used the Cluster filter, this will be the output. It varies depending on the filters I used.
If I understand it correctly, the source string also changes.. Can you help me please how to express that?

Thank you

Was this reply helpful? Yes No