Hi all,
I am trying to store value of Level1 column of data source CustGrp to a collection varGroup where customerNo equals 1234.
I need to pass another field (say Level2) if below lookup fails to match any record in CustGrp data source.
Collect(varGroup,LookUp(CustGrp,CustomerNo = '1234',Level1));
is this possible?
Thanks,
Solved! Go to Solution.
Hi @aarnav , how is this?
With the With() Function, you can create a temporary variable just during the execution of the formula. If you put the LookUp() in this with, you can check the result afterwards and handle it.
Example:
With(
{
tempvar: LookUp(
CustGrp,
customerNo = 1234,
Level1
)
},
If(
!IsBlank(tempvar),
<Collect here>,
IsBlank(tempvar),
<other collect here>
)
)
Good luck!
With(LookUp(CustGrp,CustomerNo=1234), Collect(varGroup,Coalesce(Level1, Level2)))
Hi @aarnav , how is this?
With the With() Function, you can create a temporary variable just during the execution of the formula. If you put the LookUp() in this with, you can check the result afterwards and handle it.
Example:
With(
{
tempvar: LookUp(
CustGrp,
customerNo = 1234,
Level1
)
},
If(
!IsBlank(tempvar),
<Collect here>,
IsBlank(tempvar),
<other collect here>
)
)
Good luck!
With(LookUp(CustGrp,CustomerNo=1234), Collect(varGroup,Coalesce(Level1, Level2)))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |