Hi @Anonymous,
Could you please share a bit more about your scenario?
Do you create an app based on your Excel table?
Further, could you please share a screenshot about your app's configuration?
For your first question, do you want to set the blank value as the default value within the Drop down control?
If the first row within your Excel table is empty, please take a try with the following workaround:
Set the OnVisible property of the first screen of your app to following:
ClearCollect(
RecordsCollection,
First(YourExcelTable),
Filter(YourExcelTable, approver_name <> Blank())
)
Or
ClearCollect(
RecordsCollection,
Filter(YourExcelTable, approver_name = Blank()),
Filter(YourExcelTable, approver_name <> Blank())
)
Then type the following formula within the Items proeprty of the Drop down control:
RecordsCollection.approver_name
For your second question, could you please share a bit more about the User ID that you mentioned? Based on the needs that you mentioned, I think you want to pull out the User ID value based on some conditions. I think the LookUp function and Filter function could achieve your needs in PowerApps.
More details about LookUp function and Filter function, please check the following article:
LookUp function, Filter function
For your third question, do these several fields that you mentioned existed within a Edit form? If these several fields that you mentioned existed within a Edit form, I think the Required proeprty of the corresponding Data cards relaetd to these fields within the Edit form could achieve your needs.
Please set the Required property of the corresponding Data cards related to these fields (within the Edit form) to following:
true
If these several fields that you mentioned are not existed within a Edit form, I think the If function and IsBlank function could achieve your needs. Please take a try with the following formula:
If(
!IsBlank(DataCardValue1.Text) && IsBlank(DataCardValue2.Selected.Value) && ... ,
Perform the logic you want to do
)
Best regards,
