I created an Excel spreadsheet with a multi-layer id system like this
I have ID and DataID setup to generate there ID's the way i want I'm just having a little trouble with the subDataID.
when creating a new form i want to check if DataID value has ever been created before and if so to create a new subDataID value 1 for that DataId value and Increimate subDataID =+1 for every time a new DataID with the same DataID is created.
Maby something like this.
if(DataIDCard.Text <> LookUp(Table,DataID),Set(subDataIdVariable,1),Set(subDataIdVariable,Max(Filter(Table2,DataID = "10"),subDataID)+1))
Solved! Go to Solution.
Hi @Anonymous ,
Do you want to check whether there's subDataID, if yes last subDataID+1, if no start from 1?
If so, the key point is to use LookUp function to get whether there's existing DataID.
You should use formula like this to get field value:
LookUp(table,condition,fieldname)
The formula that you used: LookUp(Table,DataID) will only get a record. You use use IsEmpty to justify whether that's record, not to compare a value with a record.
Try this formula:
If(
IsEmpty(LookUp(Table2,DataID=DataIDCard.Text)),
Set(subDataIdVariable,1),
Set(subDataIdVariable,Max(Filter(Table2,DataID = DataIDCard.Text),subDataID)+1)
)
Best regards,
Thanks, I find this works a lot better.
If(
IsBlank(LookUp(PeoplePurchasDev,DataID=DataCardValue6.Text,DataID)),
1,
Max(Filter(PeoplePurchasDev,DataID=DataCardValue6.Text),subDataID)+1
)
Hi @Anonymous ,
Do you want to check whether there's subDataID, if yes last subDataID+1, if no start from 1?
If so, the key point is to use LookUp function to get whether there's existing DataID.
You should use formula like this to get field value:
LookUp(table,condition,fieldname)
The formula that you used: LookUp(Table,DataID) will only get a record. You use use IsEmpty to justify whether that's record, not to compare a value with a record.
Try this formula:
If(
IsEmpty(LookUp(Table2,DataID=DataIDCard.Text)),
Set(subDataIdVariable,1),
Set(subDataIdVariable,Max(Filter(Table2,DataID = DataIDCard.Text),subDataID)+1)
)
Best regards,
Thanks, I find this works a lot better.
If(
IsBlank(LookUp(PeoplePurchasDev,DataID=DataCardValue6.Text,DataID)),
1,
Max(Filter(PeoplePurchasDev,DataID=DataCardValue6.Text),subDataID)+1
)
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 |
---|---|
191 | |
53 | |
51 | |
38 | |
37 |
User | Count |
---|---|
282 | |
97 | |
85 | |
80 | |
77 |