Answered

Get the Value as String from ForAll function?

(1) Share

Report

Posted on by flowArcade

I want to go into a collection where i store some scanned barcodes and read out (the only column in it).

Indipendet how much are in the collection i want to create a new forms submission to a SP list for every line in the collection.

Every Value of the Collection Rows sould be combined with Strings variables wich I get from an form input and than pass it all in a SP list record.

Works all fine but it wont give me the value from the collection (first line in forall loop).

Probably because the "Value"Variable from the ForAll Loop gives back a single line table? I tryed to make it with concat but it didnt work.

Name of the Collection: colBarcodes

Name of the Column in Collection: Value

On a Button OnSelect i got this code:

Set(varDataAbteilung; DataCardValueAbteilung.Text);;
Set(varDataEtage; DataCardValueEtage.Text);;
Set(varDataRaum; DataCardValueRaum.Text);;
Set(varDataNutzer; DataCardValueNutzer.Text);;
Set(varDataKST; DataCardValueKST.Text);;

ForAll(colBarcodes; 
 DataCardValueSYSID.Text = Concat(colBarcodes, Value);;
 DataCardValueAbteilung.Text = varDataAbteilung;;
 DataCardValueEtage.Text = varDataEtage;;
 DataCardValueRaum.Text = varDataRaum;;
 DataCardValueNutzer.Text = varDataNutzer;;
 DataCardValueKST.Text = varDataKST;;
 SubmitForm(Form_Erfassen))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @flowArcade,

Try updating your "ForAll" as follows.
ForAll(colBarcodes As currRecord; DataCardValueSYSID.Text = Concat(colBarcodes, Value);; DataCardValueAbteilung.Text = varDataAbteilung;; DataCardValueEtage.Text = varDataEtage;; DataCardValueRaum.Text = varDataRaum;; DataCardValueNutzer.Text = varDataNutzer;; DataCardValueKST.Text = varDataKST;; SubmitForm(Form_Erfassen))

If it shows some error add "currRecord" in front of all the fields like the following.

DataCardValueAbteilung.Text = currRecord.varDataAbteilung;;

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
flowArcade 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer. Unfortunitly it still doesent do the thing with both variants. Isnt there a possiblility to work with a loop in power apps?

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @flowArcade,

Are you using the similar code and still getting error?

ForAll(colBarcodes As currRecord; DataCardValueSYSID.Text = Concat(currRecord.colBarcodes, Value);; DataCardValueAbteilung.Text = varDataAbteilung;; DataCardValueEtage.Text = varDataEtage;; DataCardValueRaum.Text = varDataRaum;; DataCardValueNutzer.Text = varDataNutzer;; DataCardValueKST.Text = varDataKST;; SubmitForm(Form_Erfassen))

Assuming "currRecord" is a collection containing "currRecord" column of containing a table of values.

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
@flowArcade

What you are doing there is not correct, the syntax SomeControl.Text = var... is not correct.

Besides this you are terminating the parts inside your ForAll arbitrarily by using ;;
Try like this instead:

// Setting the variables from the form input Set(varDataAbteilung; DataCardValueAbteilung.Text);; Set(varDataEtage; DataCardValueEtage.Text);; Set(varDataRaum; DataCardValueRaum.Text);; Set(varDataNutzer; DataCardValueNutzer.Text);; Set(varDataKST; DataCardValueKST.Text);; // Creating a collection to hold the combined data ClearCollect(colCombinedData; ForAll(colBarcodes; { Barcode: Value; Abteilung: varDataAbteilung; Etage: varDataEtage; Raum: varDataRaum; Nutzer: varDataNutzer; KST: varDataKST }))

See if this gets you going the right direction @flowArcade

Was this reply helpful? Yes No
flowArcade 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot! This giving me a new perspective to solve the problem

Was this reply helpful? Yes No