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)

Sort by

WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 155,378 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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