What I need to do is concatenate a secondary list into a dropdown field
The fields are:
ID (SharePoint ID)
Status (Choice)
Area (Choice)
Creation date (SharePoint Standard)
Description (Multiple lines)
Would you like to limit the description field to only appear 80 characters?
My code here:
Concat(SecondaryDatabase
; Concatenate(Text(Value("ID"));Status.Value;Area.Value;Details;Created;","))
you should be separating each value in your concatenate formula with a comma instead of a semi-colon. also, with concatenate, you also should probably separate each value with something so that it is easier to read.
last thing.... the formula you have (once fixed with the above suggestions), is going to yield a text value. Dropdowns require a table, so you should also nest the entire formula with a Split(text,";") formula.... try the below and see if it works...
Split(Concat(SecondaryDatabase,Concatenate(Text(Value("ID")),",",Status.Value,",",Area.Value,",",Details,",",Created,",")),";"),";")
Hi, thanks for the help!
Here, I tried this code and got an error...
Concatenate function has invalid arguments
The screenshot:
question.... it looks like you are working in a different geographic location from me.... does Power Apps in your country require you to separate the values with ";" instead of ","? it is a comma in the US, but perhaps where you are requires a semi-colon?
Based on the screenshot you shared, it seems the Criado field is incorrect..... perhaps it is called something else in your datasource like 'CreatedDateTime" or created.value or something?.... seems as though that field is what isnt working properly in your formula.
it looks like you are working in a different geographic location from me.... does Power Apps in your country require you to separate the values with ";" instead of ","? it is a comma in the US, but perhaps where you are requires a semi-colon?
Answer: yes, here we use ";", its different, I know! haha
Based on the screenshot you shared, it seems the Criado field is incorrect..... perhaps it is called something else in your datasource like 'CreatedDateTime" or created.value or something?.... seems as though that field is what isnt working properly in your formula.
Answer: "Criado" is incorrect... But if I put here on PowerApps, doesn't call here! If I remove the field?
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 |
---|---|
181 | |
46 | |
46 | |
34 | |
33 |
User | Count |
---|---|
259 | |
87 | |
79 | |
68 | |
67 |