You’re offline. This is a read only version of the page.
47
Hi All
I have SharePoint list with 2 columns:
Code Value
aa qwe
ab tre
ac ert
which I need to convert to a record
Record:{aa:"qwe",ab:"tre",ac:"ert"}
Is there any way to do it with ForAll (or any other dynamic way)?
Thanks
There is no way to achieve this automatically in PowerApps. All column names for records must be definitively declared and cannot be implied by a formula. So, in other words, all of the column names (aa, ab and ac) need to be typed into your formula.
Given that, the following would give you want you want from your data sample:
{aa: LookUp(yourList, Code="aa", Value), ab: LookUp(yourList, Code="ab", Value), ac: LookUp(yourList, Code="ac", Value)}
I hope this is helpful for you.
Share
Report
All responses (
Answers (
