Answered

Show next value based on column with increasing name with number value

(0) Share

Report

Posted on by DennisJarnstal

Hi,

I am setting up a function where I use a form of which I want the data card to update when you click the next button. I have created all columns to have the same name with a number after, TextPage1, TaxPage2 and so on.

I want to increase the value with a variable each time you click the next button, so for example "TextPage"&varPage+1. But I cannot figure out how to make the data card read from this increasing value when it picks the column. When I use ThisItem.TextPage1 it shows the text that i want, but how do i implement it so that it works with the increasing value?

Thanks for any help you may be able to give

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @DennisJarnstal ,

Unfortunately you cannot refer to field names dynamically - you would need to hard-code it all.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DennisJarnstal 44 on at

Like (0)

Report

Hi Warren,

I havent quite been able to figure out how to hard code this into my solution, do you have any suggestion for how to fix this?

Best regards
Dennis

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @DennisJarnstal ,

Something like this - this is only the bit referring to the field

Switch( YourValueHere, 1, TextPage1, 2, TextPage2, 3, . . . . . . )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DennisJarnstal 44 on at

Like (0)

Report

Thank you for your help, how unfortunate that there wasnt a smoother way to make it 🙂 have a great day

Was this reply helpful? Yes No